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.

N8227PUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-194 N825SDGreat Valley Management Inc · New Castle, DEFirst renewal noticeBuilt 1996 · S/N LJ-1449 N825STLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1989 · S/N BB-1320 N826WGSibi LLC · Indianapolis, INBuilt 2000 · S/N BB-1710 N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103 N827KBArkansas Air Partners LLC · Jonesboro, ARBuilt 1978 · S/N LW-287 N828FCGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1436 N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252 N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708 N82BCGulf Air Aviation Inc · Wilmington, DEBuilt 1989 · S/N LJ1222 N82XPJones Harry R Jr · Houston, TXBuilt 1982 · S/N LJ-1012 N83Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-18 N831MWKdm Ltd · Santa Teresa, NMS/N BB-1850 N838PSNocom Aviation LLC · Stratford, TXBuilt 1983 · S/N BB-1084 N83FEG&C Aviation LLC · Wilmington, DEBuilt 1977 · S/N LW-219 N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621 N83KACcs Enterprises LLC · Maryville, TNBuilt 1983 · S/N BB-1111 N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283 N83RWEhr Ventures LLC · Jourdanton, TXBuilt 1991 · S/N LJ-1271 N83TCDel Mar College · Corpus Christi, TXBuilt 1969 · S/N LJ-483 N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289 N84Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-19 N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38 N843BCA To Z Aviation LLC · Paradise Valley, AZS/N BB-1011 N844CN844c LLC · Fort Lauderdale, FLS/N LJ-866 N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42 N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16 N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91 N84GDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-33 N84JLChieftain Equipment LLC · Longview, TXBuilt 1980 · S/N LA-18 N84PCAviation Enterprises LLC · Longwood, FLBuilt 1981 · S/N BB-860 N851KADodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N LJ-851 N858GFCal-Ore Life Flight LLC · Brookings, ORS/N BB-1858 N859GAIsr Platforms LLC · Mclean, VABuilt 1980 · S/N BT-12 N85DRWashington Air LLC · Richland, WABuilt 1978 · S/N LJ-767 N85GWMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1976 · S/N LJ-712 N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498 N85LGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N LJ-1487 N85PCSolomon Mark Trustee · Wilmington, DEBuilt 1990 · S/N LJ-1262 N85TBCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N LJ-833 N85XPB&J Aircraft LLC · Alice, TXS/N BB1202 N860GCHiggins David L · Chevy Chase, MDBuilt 1986 · S/N BB-1245 N868RXAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-84 N870SCElite Air LLC · Jonesboro, ARBuilt 1978 · S/N LJ-773 N873AFDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1984 · S/N BB-1200 N874SPSamaritans Purse · Boone, NCBuilt 1981 · S/N BB-874 N875DMKilo Alfa 200 LLC · Bakersfield, CABuilt 1990 · S/N BB-1354 N87699Pjh Consulting LLC · Reno, NVBuilt 1981 · S/N BB-887 N876PAPax.Dei LLC · Hot Springs, ARBuilt 1977 · S/N LJ-757 N877PAPax Dei LLC · Hot Springs, ARS/N BB-1844

Back to AD 87-22-01 R1