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.

N534AWCsi Aviation Inc · Killeen, TXBuilt 1988 · S/N FA154 N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152 N536ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-21 N537ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-27 N53APLta Group Holdings LLC · Amarillo, TXS/N LJ-1700 N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629 N53CEEngineering And Mfg Svcs Inc · Huntsville, ALBuilt 1975 · S/N LW-160 N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552 N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201 N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186 N53RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-195 N53TJNion LLC · New Century, KSBuilt 1989 · S/N LJ-1209 N53WDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-53 N540MAN540ma LLC · Metairie, LABuilt 2001 · S/N BB-1765 N541JGLogistics Alaska LLC · Anchorage, AKBuilt 1981 · S/N BB-989 N541LMCorsair Two LLC · Hillsboro, ORBuilt 2005 · S/N BB-1899 N541MCDynamic Avlease Inc · Bridgewater, VAS/N LM-39 N541SCKing Air N541sc LLC · Fresno, CABuilt 1987 · S/N FA-138 N5431MReach Air Medical Services LLC · Santa Rosa, CABuilt 2002 · S/N LJ-1673 N543GATriple A LLC · Savannah, GABuilt 1999 · S/N LJ-1558 N543HCMay Cattle Co LLC · Campbellton, TXBuilt 2001 · S/N LJ-1620 N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191 N545LMAero Air LLC · Hillsboro, ORBuilt 1982 · S/N BB-1069 N546CNCwn LLC · Wilmington, DEBuilt 1974 · S/N LJ609 N546LMAero Air LLC · Hillsboro, ORBuilt 1985 · S/N BB1235 N549BRCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N LJ-809 N54CHLawsuit Air LLC · Onalaska, TXBuilt 1989 · S/N FA-188 N54FDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-46 N54PTMccall Transport LLC · Portland, ORS/N LW-331 N54USSilver Eagle Express LLC · Orange, CABuilt 1981 · S/N BE122 N550SPBh Sabbah LLC · Visalia, CABuilt 1997 · S/N BB-1572 N551CNChoctaw Nation Of Oklahoma · Durant, OKBuilt 1993 · S/N LJ-1347 N551LJA-Pro LLC · Hernando, MSBuilt 1999 · S/N LJ-1551 N552BSBroken Arrow Crop Insurance Inc · Perryton, TXBuilt 1979 · S/N LJ-836 N555HJFlycarolina King Air Partners LLC · Charlotte, NCBuilt 1994 · S/N LJ-1378 N555VWTp Aviation LLC · Auburn, ALBuilt 1993 · S/N LJ-1330 N555WERfs Equipment LLC · Newport Beach, CAS/N BB-1490 N555XYNware Aviation Inc · Dover, NHBuilt 1997 · S/N LJ-1488 N556ALEaglemed LLC · Wichita, KSBuilt 1999 · S/N BB-1670 N55ADynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-55 N55HCMile High Club Of Texas LLC · El Paso, TXBuilt 1975 · S/N LW-134 N55MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 1981 · S/N LJ-974 N55PCCteh Leasing LLC · N Little Rock, ARBuilt 1983 · S/N BB-1170 N55RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-198 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N55WFIcm Inc · Colwich, KSBuilt 1985 · S/N LJ-1114 N55ZREuroaviaition Inc Trustee · KematenBuilt 1999 · S/N LJ-1566 N561KGGehrair LLC · Palm Beach Gardens, FLBuilt 1991 · S/N FA-212 N561ZAZulu Air LLC · Opa Locka, FLS/N BB1180 N5641XBuche-Air LLC · Sioux Falls, SDBuilt 1990 · S/N LJ-1241

Back to AD 87-22-01 R1