Registered aircraft · 20,481

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N9992ZAdvanced Placement Aviation LLC · Eagle River, AKBuilt 1984 · S/N U20606800 N9993BTurinsky Anthony · Anchorage, AKS/N 34393 N9993THusbands Jason · Belen, NMBuilt 1960 · S/N 18253093 N9994EBeard Michael W · Eveleth, MNBuilt 1975 · S/N 18264054 N9994HCasey James D · Burlington, MABuilt 1982 · S/N 18268169 N9994NBoynton Scott · Campbell Hall, NYS/N 18052649 N9995BAlbatross Air Inc · Mccall, IDS/N 34395 N9995EWilliams Dean W · Punta Gorda, FLBuilt 1975 · S/N 18264055 N9995NIrvine Hollis E Jr · Greenwich, NJBuilt 1975 · S/N 18052650 N9996EMeier Sally A · Lac Du Flambeau, WIBuilt 1975 · S/N 18264056 N9996HStrong Jennifer E Trustee · Lakeport, CABuilt 1982 · S/N 18268171 N9996JDiamond X LLC · Elko, NVBuilt 1982 · S/N T18803925T N9996MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700779 N9996NMorrison Otto M · Harrisburg, ARFirst renewal noticeS/N 18052651 N9997EAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N 18264057 N9997PSullivan Michael · Cazenovia, NYBuilt 1969 · S/N 18260018 N9997TFrazer Scott Cameron · Durango, COBuilt 1960 · S/N 18253097 N9998HBas Part Sales LLC · Greeley, COBuilt 1982 · S/N 18268172 N9998JBecker Flying Service Inc · Hartington, NES/N T18803927T N9998NFoulk William H · Shelburne, VTBuilt 1976 · S/N 18052653 N9998TTilley Melvin D · Sperry, OKBuilt 1960 · S/N 18253098 N9998XSells James O · Peachtree City, GABuilt 1961 · S/N 185-0198 N9999BMccole Kevin · Brookline, NHBuilt 1957 · S/N 34399 N9999TN9999t LLC · Boulder, COS/N 18253099 N9999XBogart Sean A · Anchorage, AKBuilt 1961 · S/N 185-0199 N999AGClark Chase H · Ozona, TXS/N 18052029 N999BMDewitt Stephen R · Port Aransas, TXS/N R18200072 N999CFPerkins Nathan Zackery · Bonanza, ORBuilt 1960 · S/N 52450 N999DGFoghorn Airfleet LLC · Columbus, INBuilt 1973 · S/N 18261688 N999DKSkt Seaplanes LLC · Huntsville, ALBuilt 1953 · S/N 30359 N999JFPrt LLC · Pottsboro, TXBuilt 2025 · S/N 18283305 N999JJAlpine Holdings LLC · Kalispell, MTBuilt 1976 · S/N 18264642 N999KBBurgess James H · Cora, WYBuilt 1969 · S/N 18259741 N999MHDetiger Elizabeth · East Stour DorsetBuilt 1948 · S/N 7168 N999MJKoelbl Aviation LLC · Whitesboro, TXBuilt 2019 · S/N 18283069 N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694 N999TKPearson John L · Stevensville, MTBuilt 1963 · S/N 18254831 N999UCLinville Rex D Trustee · Sarasota, FLBuilt 1973 · S/N 18261957 N999YDTru North LLC · Sterling, AKBuilt 2001 · S/N 18281026 N99ABrown Ashley A · Fort Worth, TXS/N 18052789 N99DDLussier John A · Greene, RIBuilt 1959 · S/N 50419 N99DSToutant Roland J · Woodstock, CTBuilt 1972 · S/N 210-59608 N99FC4th Street Group LLC · Signal Mountain, TNS/N 18268381 N99FEN99fe Aircraft Services LLC · Lubbock, TXS/N 18260751 N99GBBright Edgar H · Collegeville, PABuilt 1973 · S/N 21060115 N99GFDemon Diversified LLC · Wilmington, DEBuilt 1979 · S/N 18267418 N99HPMckee Eli · Brighton, COBuilt 1964 · S/N 185-0709 N99JFPeep Air LLC · Rogers, ARBuilt 2009 · S/N 18282150 N99MVWinkler Gabriel M · Kailua Kona, HIBuilt 1975 · S/N 18263592 N99QTNielsen4 LLC · Seattle, WABuilt 1968 · S/N U206-1017

Back to AD 84-10-01 R1