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.

N547MChapman Joseph Quinn · Seminole, FLBuilt 2022 · S/N 18283167 N547MCS & J Ventures Inc · Wilmington, DEBuilt 2000 · S/N 18280692 N5481E81 Echo LLC · Cincinnati, OHS/N 18268325 N5481NUlrey Stephen S · Lake Bluff, ILBuilt 1981 · S/N 18267750 N5482BWetzel Ryan M · Midland, MIBuilt 1956 · S/N 33482 N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764 N5482TDavis Thomas E · Wisconsin Rapids, WIBuilt 1982 · S/N R18201877 N5484BUnwrapped LLC · Dover, DEBuilt 1956 · S/N 33484 N5484NYeoul 182 LLC · Sanford, FLBuilt 1980 · S/N 18267752 N5485BSutton Aircraft Salvage LLC · Palmer, AKS/N 33485 N5486ABas Part Sales LLC · Greeley, COS/N 21063464 N5486BVerhaaren Inc · Naples, FLBuilt 1956 · S/N 33486 N5488SJanssen Paul · New Castle, INBuilt 1980 · S/N R18201586 N5489BNewhouse David · Belvidere, NJBuilt 1956 · S/N 33489 N548PGuin Wilson L · Alamogordo, NMS/N 33480 N548RGosnell Christopher Carter · Magnolia, ARBuilt 2005 · S/N 18281576 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5490ERoberson Terry K · Tampa, FLBuilt 1983 · S/N 18268327 N5491BSmith Richard D II · Luthersville, GABuilt 1956 · S/N 33491 N5491NLacefield Tommie C · Niceville, FLBuilt 1980 · S/N 18267756 N5493AValley Dairy Farms Inc · Roy, WAS/N 21063469 N5493NOcaid Equipment Leasing LLC · Spring Valley, NYBuilt 1980 · S/N 18267757 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N5495BCable Strong Aircraft Holdings LLC · Tyler, TXS/N 33495 N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964 N5496EFair John C · Rockport, TXBuilt 1983 · S/N 18268328 N5497BBlue Sky Powers N5497b LLC · Dover, DEBuilt 1956 · S/N 33497 N5497NBeelieve LLC · Carmel, INBuilt 1980 · S/N 18267760 N549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedS/N 20608052 N54AFSpohnholz Randy K · Anchorage, AKBuilt 1954 · S/N 30943 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54BKDanny J Daigle LLC · Greenville, MEBuilt 1981 · S/N 18268073 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N54EMAvirone Ltd · Monsey, NYBuilt 1998 · S/N 18280399 N54GVAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700447 N54KDSawtooth Flying Service Inc · Mccall, IDBuilt 1981 · S/N U20606181 N54KPScheuers Alan · Murfreesboro, TNBuilt 2005 · S/N 18281542 N54MEZhang Ning · Edmond, OKS/N P20600641 N54MMGwinn Roger A · Maple, NCBuilt 1979 · S/N 21063756 N54PWScheffers Lee · Riverside, CABuilt 1979 · S/N 18266804 N54RAerometrix LLC · Lawrence, KSBuilt 1981 · S/N 21064514 N54RWBaylis Thomas B · Hattiesburg, MSBuilt 1966 · S/N 18256924 N54SDJerry W And Barbara J Smith Family Land Lllp · Blanca, COBuilt 1954 · S/N 31162 N54TVAllen And Lambert Inc · Bolingbroke, GABuilt 1975 · S/N 18264264 N54WCFlorian Nathan A · Homosassa, FLBuilt 1961 · S/N 18253465 N54WDHat Creek Aviation LLC · Hamilton, MTBuilt 1981 · S/N R18201709 N5500BKay James L · Irvine, CABuilt 1956 · S/N 33500 N5501BSeymour George N · Shelby, MTBuilt 1956 · S/N 33501 N5508BBohner Richard A · Pls Vrds Est, CABuilt 1956 · S/N 33508 N5508SKimmel Frank S III · Greenwood, MSS/N 188-0008

Back to AD 84-10-01 R1