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.

N921AZArizona Department Of Public Safety · Phoenix, AZBuilt 1988 · S/N BB-1287 N921MFPuerto Coral Corp · Wilmington, DEBuilt 1980 · S/N LA62 N922ALBallard Aviation Inc · Newton, KSS/N BB1529 N922JCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N LJ-1665 N923CRWc&R LLC · Austin, TXBuilt 1984 · S/N LJ-1074 N924JBN924jb LLC · Little Rock, ARBuilt 2004 · S/N BB-1849 N925ARRnjs Products LLC · Lewes, DEBuilt 1977 · S/N LJ-725 N926TJBlackhawk Consulting LLC · Raceland, LABuilt 1999 · S/N BB-1662 N927JTPikes Peak Flyers Llp · Colorado Springs, COBuilt 1991 · S/N LJ1263 N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608 N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482 N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630 N929FDFaust Distributing Co Inc · Houston, TXBuilt 2000 · S/N LJ-1585 N92BDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-132 N92DVMile Hi Skydivers Inc · Longmont, COS/N LW-292 N92JDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LU-12 N92JTHigh Shadow LLC · Roach, MOBuilt 1980 · S/N LA-73 N92RKSnk Real Property Holdings LLC · Meta, MOBuilt 1996 · S/N LJ-1458 N92SCalcasieu Parish Jury Mosquito Control · Lake Charles, LAS/N LU-05 N92WCAviation Group LLC · Wilmington, DEBuilt 1989 · S/N BB-1330 N92WEInce Aviation LLC · Dover, DEBuilt 1984 · S/N LJ1090 N930KThree Zero Kilo LLC · Costa Mesa, CABuilt 1967 · S/N LJ-294 N930MCCorporate Flights LLC · Mishawaka, INS/N LJ-1720 N930MQGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1463 N931GGPc Aviation LLC · Albany, GABuilt 1999 · S/N LJ-1572 N933RTZito Aviation LLC · La Salle, COS/N BB-955 N935AJDouble C Air LLC · Sacramento, CABuilt 1981 · S/N BB-935 N935AMAirmed International LLC · Birmingham, ALBuilt 1994 · S/N LJ-1356 N939BWPoky Feeders Inc · Scott City, KSBuilt 1989 · S/N FA175 N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63 N93AMAsm Aviation LLC · Bismarck, NDBuilt 1982 · S/N LA166 N93JDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1970 · S/N LM-128 N93LPKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N LJ-901 N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13 N93VDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LU-03 N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80 N940HCAll Aviation LLC · Hudson, WIBuilt 1988 · S/N BB-1303 N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731 N944CWby Enterprises II LLC · Jackson, TNBuilt 2001 · S/N BB-1749 N944KCarmine Labriola Inc · Scarsdale, NYBuilt 1969 · S/N LJ-467 N944TFCornerstone Leasing Of The Texas Panhandle LLC · Panhandle, TXBuilt 1976 · S/N LW-177 N946AMGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1978 · S/N LJ-815 N946CGJk Aviation LLC · Grosse Ile, MIBuilt 1989 · S/N FA-198 N947AMDavis Aviation Inc · Brandon, MSBuilt 1990 · S/N LJ-1238 N948AMGuardian Flight LLC · South Jordan, UTBuilt 1989 · S/N LJ-1210 N948CEPro-Serve Aviation LLC · Englewood, COBuilt 2000 · S/N BB-1736 N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98 N949BWBering Air Inc · Nome, AKS/N BB-1763 N949CFTee Pee Wings LLC · San Angelo, TXS/N BB-1828 N949MAMajestic Aviation LLC · Billings, MTBuilt 2002 · S/N BB-1795

Back to AD 87-22-01 R1