Registered aircraft · 1,915

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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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-22-01-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.

N50BRBartholow Rental Company Inc · Wylie, TXBuilt 2001 · S/N LJ-1632 N50EDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BL7 N50EBDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-128 N50GGN50gg Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1728 N50KGTurbo Air Charter LLC · Boise, IDBuilt 1982 · S/N BB-1066 N50NABv Transportation LLC · Portland, ORBuilt 1995 · S/N BB1504 N50PACenterline Aviation Inc · Middletown, DEBuilt 1988 · S/N BB-1308 N50PDParker Long LLC · Lexington, NCS/N LJ-1704 N50VPDale Aviation Inc · Rapid City, SDBuilt 1988 · S/N LJ-1185 N50XDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N BB-1239 N510GSAmdel Holding LLC · Houston, TXBuilt 2001 · S/N BB-1746 N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136 N511DPAir Med Services LLC · Lafayette, LABuilt 1981 · S/N BL-15 N511GAGeaux Aire LLC · Savannah, GABuilt 1993 · S/N BB1462 N511KVDelta Fox LLC · Woodland, CABuilt 1995 · S/N LJ1422 N511TAAir Med Services LLC · Lafayette, LABuilt 1999 · S/N BB-1660 N511WMD&D Industries Inc · Monclova, OHBuilt 1973 · S/N LW-57 N513JMBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N LJ-1274 N514TBFast Marketing Strategies LLC · Royal Oak, MDBuilt 1990 · S/N BB-1351 N515GKAvintel Management LLC · Dublin, OHBuilt 1974 · S/N LW-108 N51685Midland Avionics LLC · Louisville, KYS/N LC-40 N518AGKangaru Enterprises LLC · Solvang, CABuilt 2002 · S/N LJ-1671 N518TSAerolease LLC · Fargo, NDBuilt 1986 · S/N LJ-1130 N519RRCgs 2003 LLC · San Leon, TXBuilt 1978 · S/N BE-40 N51DNDjl Investments LLC · Gilroy, CABuilt 1972 · S/N LW-7 N51RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-212 N520DGDanzer Veneer Americas Inc · Darlington, PABuilt 2001 · S/N BB-1753 N521FTR & G Aviation LLC · Hazlehurst, GABuilt 1980 · S/N BL-012 N522MJPpr2 Inc · Jackson, MSS/N LW-80 N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BL-142 N525SKCb4 LLC · Wilmington, DEBuilt 1983 · S/N BB-1148 N526RRDaytona Hot Cars Inc · Port Orange, FLBuilt 1967 · S/N LJ-263 N527CHSafeco Leasing LLC · Port Alsworth, AKBuilt 1981 · S/N BB-899 N527QSilver Linings Air And Farm LLC · Chamblee, GABuilt 1968 · S/N LC-284 N529NANasa Langley Research Center · Hampton, VAS/N BB-1091 N52CSpritzair LLC · North Palm Beach, FLBuilt 1981 · S/N BB-992 N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42 N52LDynamic Avlease Inc · Bridgewater, VAS/N BT-31 N52RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-210 N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301 N530LMCorsair Two LLC · Hillsboro, ORBuilt 1999 · S/N BB1678 N531AWCsi 135 Division LLC · Albuquerque, NMBuilt 1986 · S/N FA-98 N531CBSpectre Aviation LLC · Dover, DEBuilt 1983 · S/N BE-133 N531LMCorsair Two LLC · Hillsboro, ORS/N BB1852 N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218 N532LMCorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N BB-1996 N533GGClf Houston Travel LLC · Houston, TXBuilt 1998 · S/N LJ-1533 N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197

Back to AD 87-22-01 R1