Skip to content

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.

N5616BCasey Joseph · Buffalo, WYBuilt 1956 · S/N 33616 N5617BTruck Plus · Nampa, IDBuilt 1956 · S/N 33617 N56180Gosney Don L · Bayfield, COBuilt 1955 · S/N 32165 N561ATSheets Jeff M · Salmon, IDBuilt 1956 · S/N 32403 N561MBVital Equipment LLC · Midland, TXBuilt 2004 · S/N 18281425 N561SPIllinois State Police · Springfield, ILBuilt 2000 · S/N 18280825 N5620BBend Aircraft Rentals LLC · Bend, ORBuilt 1956 · S/N 33620 N5620GWilliams Dean Nelson · San Antonio, TXS/N U20603751 N5620JPearce Gregory W · Eagle River, AKBuilt 1974 · S/N 18263474 N5621BArtz James R · White Bird, IDFirst renewal noticeBuilt 1956 · S/N 33621 N5621XDiorio Joseph · Murrieta, CABuilt 1971 · S/N 18260796 N5622ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1983 · S/N 18268334 N5627BTaylor Tona R · Graham, WABuilt 1956 · S/N 33627 N5628JAviate 208 LLC · Oconomowoc, WIBuilt 1974 · S/N 18263476 N562ATOmahen Gilbert H · Northridge, CABuilt 1974 · S/N 18263227 N562CBKqm Aviation · Bristow, VABuilt 2010 · S/N 18282207 N562DGB2d LLC · Wickenburg, AZBuilt 1976 · S/N 21061684 N562SVAv8tr Holdings LLC · Kent, NYBuilt 1978 · S/N 18266238 N5630BJohnstone Karl S · Anchorage, AKBuilt 1956 · S/N 33630 N5631BZufelt Robert H · Nampa, IDBuilt 1956 · S/N 33631 N5632BPasahow David R · Fredericksburg, TXS/N 33632 N5637GN2893e LLC · Reno, NVBuilt 1974 · S/N 18263304 N5638BBowman David R · Julian, NCBuilt 1956 · S/N 33638 N5640BN5640b LLC · Ashburn, VABuilt 1956 · S/N 33640 N5641BGoebel William R · Rhome, TXBuilt 1956 · S/N 33641 N5642JGreater Houston Soaring Association · Needville, TXBuilt 1969 · S/N 18800592 N5644BSchmidt Ross A · D-63329 EgelsbachNon-citizen corporation, flight hours not reportedBuilt 1956 · S/N 33644 N5645BHenderson William R · Ohatchee, ALBuilt 1956 · S/N 33645 N5646BSkydive Ky LLC · Cecilia, KYS/N 33646 N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129 N5648BBailey Carl · Huntington, WVBuilt 1956 · S/N 33648 N5648JSswb Enterprises LLC · Lufkin, TXBuilt 1974 · S/N 18263479 N564CMurray Robert G · Eudora, KSBuilt 1964 · S/N 185-0656 N564LMSky Horse LLC · Santa Cruz, CABuilt 2012 · S/N 20608340 N564PCHargest Custom Cabinetry LLC · Clermont, NJBuilt 1998 · S/N 18280248 N5650BPlane Life LLC · Wilmington, DEBuilt 1956 · S/N 33650 N5653BKey Jon · Seminole, TXFirst renewal noticeBuilt 1956 · S/N 33653 N5658BSheyman Igor · Danville, CAS/N 33658 N5659BAom Aircraft LLC · Wilmington, DEBuilt 1956 · S/N 33659 N5659JGilbert Duane A · Reno, NVBuilt 1974 · S/N 18263481 N565CMBackcountry Aviation LLC · North Salt Lake, UTBuilt 1968 · S/N U2061044 N565KGGilley Jerry · Maryville, TNBuilt 1973 · S/N 18261775 N565MCAviator Air Flight School LLC · Grand Prairie, TXBuilt 2000 · S/N 18280782 N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347 N565SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608188 N565SMMuller Scott B · Verbank, NYS/N 18267914 N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065 N5660BHarlow Brett · Pryor, OKBuilt 1956 · S/N 33660 N5661BPiekarski John G · Kuna, IDBuilt 1956 · S/N 33661 N5662BHollibird Aviation LLC · Knightdale, NCBuilt 1956 · S/N 33662

Back to AD 84-10-01 R1