Registered aircraft · 72,010

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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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.

N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379 N3737WVoss James S · Soldotna, AKS/N 32-651 N3738MAnsell Nathan D · Mukwonago, WIS/N 32R-7885013 N3738WNewton Machine Co Inc · Charlotte, NCBuilt 1966 · S/N 32-652 N3739EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960076 N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378 N3739WPacific Gold Aviation Association · Roseville, CABuilt 1966 · S/N 32-653 N373BSPenn Mitchell · Poplar Bluff, MOBuilt 1969 · S/N 28-26555 N373CACoco Aircraft Inc · Merritt Island, FLBuilt 1988 · S/N 2841014 N373EADallas Collins Prison Services Inc DBA · Devine, TXBuilt 1976 · S/N 61P-0373-120 N373EWBaker Sheryl Wolff · Elbert, COS/N 80476 N373HPHandal Fred · Ladera Ranch, CABuilt 2001 · S/N 3257245 N373JWSousek Samuel V II · Shawano, WIBuilt 2020 · S/N 70373 N373MAKropf Kevin G · Montrose, COBuilt 1999 · S/N T20608117 N373MBBurks Michael S · Haslet, TXBuilt 2004 · S/N 1178 N373MKNorth Star Aviation · Mankato, MNBuilt 2025 · S/N 2881986 N373RPHoward Mark C · Edmond, OKBuilt 2001 · S/N 3212 N373SAnderson Thomas · Brooklyn, NYBuilt 1995 · S/N 1 N373SERegistration Pending · Phoenix, AZRegistration pendingBuilt 1996 · S/N 18-506 N373WDBeardall Ann · Kiowa, COBuilt 2004 · S/N T18208264 N3740TBibbey Mark A · Chandler, AZBuilt 1967 · S/N 28R-30049 N3740XBarnato Peter M · Twain Harte, CABuilt 1968 · S/N 5050 N3740ZCarl Eric Storm Trustee · Eagle River, AKBuilt 1966 · S/N 18-7496 N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984 N3741TIowair Inc DBA · Atkins, IABuilt 1968 · S/N 28R-30957 N3741ZStanton Morgan · Anchorage, AKBuilt 1963 · S/N 18-7497 N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755 N3742WRibas Daniel · Atascadero, CABuilt 1966 · S/N 32-656 N3742XHancock John R · Poplarville, MSBuilt 1968 · S/N 5052 N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463 N3743QTonneson Rollin J · Souris, NDBuilt 1977 · S/N 28-7790464 N3743XHenderson Douglas A · Springerville, AZBuilt 1968 · S/N 5053 N3744PCaplinger Jimmy C · Justin, TXBuilt 1955 · S/N 22-3464 N3744TAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30054 N3744XLongwill Dusty J · Raton, NMBuilt 1968 · S/N 5055 N3744ZWild About Nature LLC · Fairbanks, AKBuilt 1960 · S/N 18-7502 N3745KMangels Christopher L · Wasilla, AKBuilt 1946 · S/N 1438 N3745THill James C · Grand Saline, TXS/N 28R-30055 N3746MParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816372 N3746PSale Reported · Fort Lauderdale, FLSale reported, canceledS/N 31-7752095 N3746THeinemann Daniel J · Lynchburg, TNBuilt 1968 · S/N 28R-30958 N3746WN3746w Corp · Wilmington, DEBuilt 1966 · S/N 32-660 N3746ZButtrick Jason · Anchorage, AKS/N 18-7504 N3747KBelcher Randall Mcarthur II · Lake Havasu City, AZBuilt 1967 · S/N 28-23718 N3747PRegistration Pending · Sterling, AKRegistration pendingBuilt 1955 · S/N 22-3467 N3748PStade Joel T · Iowa Park, TXS/N 22-3468 N3748TBaki Christian · Ocoee, FLBuilt 1967 · S/N 28R-30058 N3749Neuville Gregory L · Fort Myers, FLFirst renewal noticeBuilt 1979 · S/N AA5B1097 N374AMMara Andrew M · North Kingstown, RIBuilt 2023 · S/N 1726 N374BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881774

Back to AD 87-10-06 R1