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.

N800QACitadelle Holdings LLC · Palmetto Bay, FLBuilt 1962 · S/N LD-29 N800TSPetrie Motor Company Inc · Lake Worth, TXBuilt 1982 · S/N BB-1032 N801NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1983 · S/N BB-1164 N8021PArc-170 Aviation LLC · Santa Claus, INBuilt 1990 · S/N LJ-1269 N803HCH J King Air LLC · Madison, GAS/N LA-99 N806JGGallagher James · Thornhurst, PABuilt 1989 · S/N UC63 N806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLS/N BC-22 N806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1981 · S/N BB990 N806LWSac Wild LLC · Loomis, CABuilt 1994 · S/N BB-1494 N806WBCircle I Air LLC · Lubbock, TXBuilt 1982 · S/N BB-1047 N807SMAurora Air Partners LLC · Portland, ORBuilt 2007 · S/N BB-1989 N808BESkyfall Aviation LLC · Blacksburg, VABuilt 1988 · S/N BB-1312 N808SWFmgi Inc · Woodstock, GABuilt 1978 · S/N LJ801 N8096UWhitty Aviation LLC · Rocklin, CABuilt 1993 · S/N LJ-1326 N809DMAir Reldan Inc · Slidell, LABuilt 1980 · S/N LW-334 N809HCCourson Oil And Gas Inc · Perryton, TXS/N BB-1864 N80BTCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N LW-148 N80BZMiddle Tennessee State University · Murfreesboro, TNS/N FA-117 N80RDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-21 N80RRBemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-296 N80YDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-79 N81Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-16 N8108REdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LC-329 N810ADGulf States Air Inc · Bossier City, LAS/N LD-328 N810RDKing Air N810rd LLC · Bluffton, SCS/N LJ-1691 N810TCSanborn Map Co Inc · Colorado Springs, COBuilt 1984 · S/N FA-002 N811KCTwa International Inc · Cheyenne, WYFirst renewal noticeBuilt 1979 · S/N LJ-869 N812ACInternational Air Services Inc Trustee · Carson City, NVS/N LJ-123 N812CRWayne Halfway House Inc · Waynesboro, TNS/N LJ-1695 N812GBTrinity Logistics Holdings LLC · Saint Johns, FLBuilt 1980 · S/N LA-72 N812TTBranched Oak Charter LLC · Rising City, NEBuilt 1985 · S/N BB-1207 N813BLSarma Aviation LLC · Fort Wayne, INBuilt 1978 · S/N BE-55 N813JBDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-899 N814LCN814 LLC · Dover, DEBuilt 1990 · S/N LJ1247 N8156ZWings Of Dawn LLC · Valley Center, KSBuilt 1993 · S/N LJ-1333 N816BSN811kc LLC · Sunrise, FLBuilt 1992 · S/N BB-1440 N817BAZane Bennett Galleries LLC · Santa Fe, NMBuilt 1981 · S/N BB956 N817MSCarmarc II LLC · Miami, FLBuilt 2001 · S/N LJ-1629 N81820Uas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N U232 N818FWPelican Aircraft Inc · Wilmington, DEBuilt 1991 · S/N BB-1394 N819MHC&W Logistics LLC · Garden City, KSFirst renewal noticeBuilt 1977 · S/N LJ-735 N81ETRussell Timothy Lee Jr · Saint Petersburg, FLBuilt 1998 · S/N BB1625 N81HPFly Buys Too LLC · Wilmington, DEBuilt 1973 · S/N LW-72 N81SUMedary Aviation LLC · Brookings, SDBuilt 1989 · S/N LJ-1194 N820DLEs&E Aviation LLC · Greensboro, NCS/N BB-1820 N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82 N821CBEz Transportation Inc · Rosharon, TXBuilt 1977 · S/N BE-35 N821SFAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-121 N821VVElite Team Offices Inc · Clovis, CABuilt 1977 · S/N LJ-714 N8226ZUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-190

Back to AD 87-22-01 R1