Registered aircraft · 3,960

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-21-02-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N246BGuynn Dane L · Peachtree City, GAS/N 310K0030 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253 N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817 N247CTConsolidated Technologies · Woodbury, MNBuilt 1961 · S/N 320-0058 N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N24GBSmith Loren · Great Falls, MTS/N 421C0287 N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631 N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311 N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251 N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242 N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984 N254CMGatewood Crisp · Tifton, GABuilt 1975 · S/N 310R0254 N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504 N254TM56h LLC · St Simons Island, GABuilt 1979 · S/N 414A0254 N255MBPhoenix Aircraft Management LLC · Marathon, FLFirst renewal noticeBuilt 1968 · S/N 310N-0110 N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606 N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071 N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336 N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043 N25EWBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 310K0063 N25FERound Trip Lc · Elkhart, KSS/N 421-0055 N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538 N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004 N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064 N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072 N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092 N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112 N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101 N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321 N2617NFlightcentrx LLC · Peachtree City, GAS/N 414A0273 N2618LFl & J Air Corp · West Orange, NJBuilt 1979 · S/N 414A0284 N2618VPlatz James · Auburn, MES/N 414A0285 N2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 414A0290 N2619LAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1979 · S/N 414A0291 N2619Z4j Air LLC · Cartersville, GABuilt 1979 · S/N 414A0293 N261ALCkm Aircraft Holdings I LLC · Mandan, NDBuilt 1978 · S/N 414A0207 N262MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 421C0140 N2631SAsplundh Eric P · Bryn Athyn, PABuilt 1979 · S/N 310R1620 N2632BHeubeck Associates Inc · New York, NYBuilt 1979 · S/N 310R1626 N2634KKoeppel Steven Lynn Trustee · Mckinney, TXS/N 310R1637 N26355Fay Andrew T · San Marcos, TXS/N 310R1645 N2635XN2635x LLC · Eau Claire, WIS/N 310R1642 N26370Gv Air Inc · Medford, ORBuilt 1979 · S/N 310R1659

Back to AD 87-21-02 R1