Registered aircraft · 3,961

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.

N340TBBerkshire Building Services Inc · South Egremont, MABuilt 1976 · S/N 340A0066 N340TG340tg LLC · Elm Springs, ARS/N 340A0730 N340THHinkle Anthony · Mineola, TXS/N 340A0501 N340TLRegistration Pending · Henderson, NVRegistration pendingBuilt 1975 · S/N 340A0018 N340TSNighthawk Flight Systems Inc · Vista, CABuilt 1980 · S/N 340A0999 N340TTPrecision Aviation LLC · Costa Mesa, CABuilt 1980 · S/N 340A1034 N340UGonzalez Pablo II · Sweeny, TXBuilt 1978 · S/N 340A0530 N340UMSouthwest Management Group Inc · Farmington, NMBuilt 1979 · S/N 340A0698 N340VAMel Hambelton Ford Inc · Wichita, KSBuilt 1979 · S/N 340A0915 N340VCStc Aviation Inc · Saint Cloud, MNS/N 340A0296 N340VLVanguard R&R Lease Co Inc · Dallas, TXBuilt 1984 · S/N 340A1811 N340VVYouth Aviation Academy · Roseville, CABuilt 1972 · S/N 340-0087 N340WPraetorian Aviation Services LLC · Alva, FLBuilt 1973 · S/N 340-0317 N340WAFoshay Laird · Paso Robles, CABuilt 1972 · S/N 340-0035 N340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNBuilt 1974 · S/N 340-0509 N340WGBartlein & Co Inc · Santa Barbara, CABuilt 1972 · S/N 340-0182 N340WHN340dg LLC · Spanish Fork, UTBuilt 1974 · S/N 340-0366 N340WJIntegritas Aviation LLC · Cedar Park, TXBuilt 1979 · S/N 340A0774 N340WMHarco Aviation LLC · Houston, TXBuilt 1978 · S/N 340A0612 N340WPNnk Holdings LLC · San Antonio, TXBuilt 1981 · S/N 340A1240 N340XCPrairie Aero LLC · Baldwin City, KSBuilt 1976 · S/N 340A0098 N340XPN340xp LLC · Wellington, FLS/N 340A0741 N340XXTaylor Christopher A · Phoenix, AZBuilt 1979 · S/N 340A0689 N340YDown The Line LLC · Newport Beach, CAS/N 340A-0404 N340YCBa Air LLC · Searcy, ARBuilt 1977 · S/N 340A0375 N340YPSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A-0990 N340YZN340yz Corp Trustee · Wilmington, DEBuilt 1976 · S/N 340A0019 N3412QPoulsen Melvin J · Orem, UTS/N 320E0012 N3417GDemark Aviation Inc · Wilmington, DEBuilt 1976 · S/N 310R0825 N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017 N3418GOppermann William A · Derby, KSBuilt 1976 · S/N 310R0826 N341ATKlodd Stephen · Granbury, TXBuilt 1978 · S/N 340A0422 N341BCAbeflies LLC · Montvale, NJBuilt 1972 · S/N 340-0015 N341BGAttack Jack Enterprises LLC · Wilmington, DEBuilt 1973 · S/N 340-0233 N341CMBc Aviation · Perham, MNBuilt 1981 · S/N 340A1255 N341HCStc Aviation Inc · Saint Cloud, MNBuilt 1979 · S/N 340A0798 N341JPRed Arrow Leasing Inc · Paw Paw, MIS/N 340A0293 N341MTI2i Logistics LLC · Wheeling, ILBuilt 1980 · S/N 340A0980 N341RBRomeo Bravo LLC · Thompson, MOS/N 421C1112 N341SCShedd Aviation LLC · Columbus, INBuilt 1984 · S/N 340A1810 N341SJAga Aviation LLC · Lewes, DES/N 340A0222 N341TVWild Hare Enterprises LLC · Valparaiso, INBuilt 1981 · S/N 340A1277 N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243 N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037 N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044 N344AHAdams Flying Service Inc · Rayville, LABuilt 1978 · S/N 310R1371 N344JSWhitewing Aviation LLC · Tuscola, TXBuilt 1979 · S/N 340A0781 N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424 N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052 N3456QL & J Aviation Inc · Atwater, CABuilt 1971 · S/N 340-0004

Back to AD 87-21-02 R1