Skip to content

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N5427HPetersen Kenton D · Jefferson, SDBuilt 1949 · S/N 18-17 N5427TNw Aircraft Sales & Leasing LLC · Scappoose, ORBuilt 1964 · S/N 17251327 N5428CSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1950 · S/N 19462 N5428HVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1963 · S/N 18-19 N5428QKruse Jakob · Parsippany, NJBuilt 1972 · S/N 15073328 N5428TBarnes Joseph A · Upper Lake, CABuilt 1964 · S/N 17251328 N5429CHenrikson Peter R · Fort Worth, TXBuilt 1950 · S/N 19463 N5429HRickman Allen K · Absarokee, MTS/N 18-20 N5429RRose Ronald R · Richland, NYBuilt 1966 · S/N 17252975 N5430CWilson William J · Aniak, AKBuilt 1950 · S/N 19560 N5430TReitz Enterprise LLC · Goliad, TXBuilt 1964 · S/N 17251330 N5431TCorbett Michael T · Lake City, FLBuilt 1964 · S/N 17251331 N5432CBarbee James E · Mason Neck, VABuilt 1950 · S/N 19466 N5432RMishmash Christopher L · Valdez, AKBuilt 1965 · S/N 17252979 N5433HHoyer Larry B · Fort Peck, MTBuilt 1950 · S/N 18-24 N5433RJones Kenneth Jr · Lufkin, TXBuilt 1965 · S/N 17252981 N5434RFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1965 · S/N 17252982 N5435QHutchins Kent F · Carbon, INBuilt 1972 · S/N 15073335 N5436TStrachn Adam · Lenoir City, TNBuilt 1964 · S/N 17251336 N5437CHand Loraine A · Tahlequah, OKBuilt 1950 · S/N 19561 N5437QMetro Technology Aviation Campus · Oklahoma City, OKBuilt 1972 · S/N 15073337 N5438TFritz James A · Pierce, NEBuilt 1964 · S/N 17251338 N5439RIndian Hills Community College · Ottumwa, IABuilt 1965 · S/N 17252989 N543BDRegistration Pending · Beaufort, SCRegistration pendingBuilt 2007 · S/N AL-1117 N543DFRichardson Daniel D · Caldwell, IDS/N 17251342 N543VKHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071227 N5440TIsland Lady LLC · Iowa Falls, IAS/N 17251340 N5441RGraham Norman J · West Ossipee, NHBuilt 1965 · S/N 17252991 N5441TCape Steven A · Columbia, KYS/N 17251341 N5442EUnterseher Pat L · Kearney, NEBuilt 1957 · S/N 36330 N5442RBarnes Terry A · Austin, TXBuilt 1965 · S/N 17252993 N5444CMathis Ryan B · Madison, ALBuilt 1950 · S/N 19478 N5444QChiavari Nicholas J · Havertown, PABuilt 1972 · S/N 15073344 N5444RAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1965 · S/N 17252995 N54459Kingdom Air Corps · Sutton, AKS/N 5-928 N5445RWimpy Gregory S · Griffin, GABuilt 1965 · S/N 17252997 N5445TSchallip Robert G III · White Lake, MIBuilt 1964 · S/N 17251345 N5447RToth Roger J · Willoughby, OHFirst renewal noticeBuilt 1965 · S/N 17252999 N5448CBeamer Nicholas J · Yuba City, CABuilt 1950 · S/N 19482 N5448TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1964 · S/N 17251348 N5449QHarper Randall W · Presque Isle, MEBuilt 1972 · S/N 15073349 N5449RMartin David · Waterport, NYBuilt 1965 · S/N 17253002 N544JPHafner Mark F · Junction, TXBuilt 2007 · S/N AL-1112 N5450RMayer Ag Service · Chamberlain, SDBuilt 1965 · S/N 17253003 N5451RYoungstown Warren Development Partners · Vienna, OHBuilt 1965 · S/N 17253005 N5452CMaas Barry M · Bothell, WABuilt 1950 · S/N 19486 N5452FRients Randall T · Virginia Beach, VABuilt 1967 · S/N B-252 N5452HGruhlkey William H · Wildorado, TXBuilt 1950 · S/N 18-43 N5452QRhein Craig · Mastic, NYBuilt 1972 · S/N 15073352 N5452RWilliams Matthew W · Auburn, WABuilt 1965 · S/N 17253006

Back to AD 94-05-05 R1