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.

N7810Danger Zone Aviation LLC · Ham Lake, MNBuilt 1971 · S/N 18260671 N78102Sonoma County Land Company Inc · Santa Rosa, CABuilt 1973 · S/N 18261751 N7810ABlack Diamond Soaring Inc · Oley, PABuilt 1957 · S/N 32707 N7810KBecker Michael A · La Grande, ORBuilt 1976 · S/N 18052744 N78115Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 18261753 N78133Dancing Buffalo LLC · Shreveport, LABuilt 1973 · S/N 18261755 N7813AKvichak Lodge LLC · Anchorage, AKBuilt 1956 · S/N 32710 N7813NOtoole Kevin H · Logandale, NVBuilt 1974 · S/N 18263290 N7818AGeoterra Inc · Eugene, ORBuilt 1956 · S/N 32715 N7819KCollins Brian D · Middlebury, VTBuilt 1976 · S/N 18052753 N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235 N781MCOster Kenneth W · Coarsegold, CABuilt 1975 · S/N 18052631 N7821AKw Air LLC · Darlington, INS/N 32718 N7821KFlood John · Bozeman, MTBuilt 1976 · S/N 18052755 N7822KStahl Richard J · Gainesville, TXBuilt 1976 · S/N 18052756 N7826GSeabold Todd J · Craig, COBuilt 1974 · S/N 18263329 N7827KTvc Fliers LLC · Traverse City, MIBuilt 1976 · S/N 18052761 N7828KMader James Jay · Lino Lakes, MNBuilt 1976 · S/N 18052763 N782CB182q LLC · Anthem, AZBuilt 1979 · S/N 18267192 N782CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281782 N782DGLasalle Investments LLC · Tucson, AZBuilt 1975 · S/N 18263557 N782RGL-Bird LLC · Hood River, ORBuilt 1978 · S/N R18200194 N782RMMbs Aviation LLC · York, SCBuilt 2005 · S/N 18281730 N7830KColberg Sigurd E · Palmer, AKBuilt 1976 · S/N 18052764 N78340Mcclellen Andrew C · Dallas, TXBuilt 1973 · S/N 18261760 N7834KSautner Steve · Anchorage, AKBuilt 1976 · S/N 18052768 N7835MTimpauer Alberto N · Mesa, AZS/N 33476 N7838KDolphin Patrick D · Kenai, AKBuilt 1976 · S/N 18052772 N783CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281783 N783ELieberg Craig M · Clear Lake, MNBuilt 1961 · S/N 18051001 N783WWThomas Michael D · Centralia, WABuilt 1998 · S/N 18280351 N78415Griffith Richard A · College Station, TXBuilt 1973 · S/N 18261763 N7841KJohnson Daniel K · Lampasas, TXBuilt 1976 · S/N 18052775 N7842CWemhoff Jason L · Coeur D Alene, IDS/N 34484 N7847CAyres Patrick C · Bend, ORBuilt 1954 · S/N 31046 N784ACRochefort Michael A · Panama City, FLBuilt 1997 · S/N 18280096 N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104 N784DRMyren Jason A · Marion, IABuilt 2003 · S/N 18281213 N784GHenry Frank P · Winnabow, NCBuilt 1977 · S/N 18265960 N784LMNorth Lake Air LLC · Lindstrom, MNBuilt 1979 · S/N 18267452 N78522Jb522 LLC · Pflugerville, TXBuilt 1973 · S/N 18261768 N7853ARegistered aircraftBuilt 1957 · S/N 32750 N7854AMacglover Richard A · Ham Lake, MNBuilt 1957 · S/N 32751 N78556B&T Venutres LLC · Duncan, OKBuilt 1973 · S/N 18261769 N7855CSitz Walter L · Burns, ORBuilt 1959 · S/N 31440 N7857AEberhardt William J · Gig Harbor, WABuilt 1957 · S/N 32754 N785BKPilot Peak Aviation LLC · Kalispell, MTBuilt 1977 · S/N 18265768 N78607Jones John E Jr · Metter, GABuilt 1973 · S/N 18261774 N7864ACrestair Air LLC · Dover, DEBuilt 1957 · S/N 32761 N7868AFox Farley R · Britt, MNBuilt 1957 · S/N 32765

Back to AD 84-10-01 R1