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.

N9198CSmith Rickey J · Port Saint Joe, FLBuilt 1954 · S/N 31297 N9198GDuckflyway LLC · Herscher, ILS/N 18260738 N91999Gembala Randall L · Kalispell, MTBuilt 1969 · S/N 18259990 N9199MBlue Sky Flyers Inc · Greeley, COBuilt 1976 · S/N 18264739 N9199TFv Arianna Sage Inc · Chignik Lagoon, AKS/N 50699 N919EHKauffman Keith · Redondo Beach, CABuilt 1959 · S/N 52391 N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054 N919RRodriguez Daniel L · West Linn, ORS/N 21059032 N91AZGulf Coast Helicopters Inc · Pearland, TXS/N 18265784 N91CCDeep Creek Aviation LLC · Ashburn, GABuilt 1978 · S/N 18266433 N91DAJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18266836 N91DJNola Knewbees LLC · New Orleans, LABuilt 1974 · S/N 18262605 N91HAHoneybee Air LLC · Newark, NJBuilt 2000 · S/N 18280913 N91LPDreisewerd William · Winfield, MOBuilt 1984 · S/N 18268423 N91PCChay Dan B · Kenai, AKBuilt 1959 · S/N 50461 N92000Clift Robert E · Anchorage, AKBuilt 1969 · S/N 18259991 N92009Will Dennis L · Clyde, MIBuilt 1969 · S/N 18259997 N9200CShepard Philip A · Trophy Club, TXBuilt 1978 · S/N R18200443 N9200GNoya Charles J · Albuquerque, NMBuilt 1971 · S/N 18260740 N9200XCochreham Bryce O · Seibert, COBuilt 1962 · S/N 18253600 N92013Burns Dale E · Kamiah, IDBuilt 1969 · S/N 18259999 N92016Campbell Kevin T · Gretna, NEFirst renewal noticeBuilt 1969 · S/N 18260002 N92018Mercenary Medical LLC · St George, UTBuilt 1969 · S/N 18260004 N92020Domaille Dennis C · Mammoth Lakes, CABuilt 1969 · S/N 18260006 N92021Pisiak Sonny S · Queen Creek, AZS/N 18260007 N9202TLander David W · Gilroy, CABuilt 1959 · S/N 50702 N9202XNohrenberg Larry R · Jamestown, NDBuilt 1962 · S/N 18253602 N92039Newwing LLC · Freeland, WABuilt 1969 · S/N 18260014 N9203CSamuel James F · Port Byron, NYS/N 31302 N9203GStohr Jeffry M · Aberdeen, SDBuilt 1974 · S/N 18263392 N9203TMartinson Douglas E · Nome, AKS/N 50703 N9203XPeru Projects Inc · Lincoln, NEBuilt 1962 · S/N 18253603 N92049Put Ronald · Alameda, CABuilt 1969 · S/N 18260019 N9204TDoner Daniel D · Highlands Ranch, COBuilt 1960 · S/N 50704 N92050Tysky Air LLC · Arvada, COBuilt 1969 · S/N 18260020 N92051Yardy Paul J · Caledon OntarioBuilt 1969 · S/N 18260021 N92054Waterheat Inc · Anchorage, AKBuilt 1969 · S/N 18260023 N92059Scott Donald · Bend, ORBuilt 1969 · S/N 18260025 N92061Wright Frederick L · Rosamond, CABuilt 1969 · S/N 18260026 N92065Meyer Ronald W · Carleton, MIBuilt 1969 · S/N 18260030 N92068Lovas Thomas A · Anchorage, AKBuilt 1969 · S/N 18260031 N92069Registration Pending · Redding, CARegistration pendingBuilt 1969 · S/N 18260032 N9206CFontenot Mitchell · Kalispell, MTBuilt 1955 · S/N 31305 N9206TZack Colson L · Hood River, ORBuilt 1960 · S/N 50706 N92074Franz Donald A · Sidney, MTBuilt 1969 · S/N 18260035 N9207CRadford Kathleen E · Anchorage, AKS/N 31306 N9207GSundin James B · Kahului, HIBuilt 1971 · S/N 18260747 N9207TRed Olive Bashir LLC · Spencerville, OHBuilt 1960 · S/N 50707 N9207XHegge Darren S · Priest River, IDBuilt 1961 · S/N 18253607 N92089Alves Randy J · Lakeview, ORBuilt 1969 · S/N 18260039

Back to AD 84-10-01 R1