Skip to content

Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N5614WColeman John H · Jackson, MIBuilt 1962 · S/N 28-754 N56158Munyon William · Vineland, NJBuilt 1973 · S/N 28-7325583 N5615QKhan Awad A · Clearwater, FLBuilt 1965 · S/N 3103 N5615WH&H Aviation LLC · Lehi, UTBuilt 1963 · S/N 28-755 N56160Thatcher Michael · Delaware, OHBuilt 1973 · S/N 28-7305543 N56161Ohmart Jeffrey A · Wichita, KSBuilt 1973 · S/N 28-7305544 N5616EDhl Skyhawk Inc · Martinez, CABuilt 1978 · S/N 17271902 N5616YBigfoot Aviation LLC · Wilmington, DEBuilt 1965 · S/N 18-8287 N5617JSale Reported · Wilton, CASale reportedBuilt 1980 · S/N 17273822 N5617PBuchheit Dirk · Lake Worth, FLBuilt 1959 · S/N 24-685 N5617QRegistration Pending · Perryton, TXRegistration pendingBuilt 1965 · S/N 3007 N5617UManagement Company Of South Carolina LLC · West Columbia, SCBuilt 1969 · S/N 28-26406 N5617WRose Dean R · Appleton, WIBuilt 1962 · S/N 28-758 N56190Bertch Gary M · Waterloo, IABuilt 1973 · S/N 28-7305550 N56198Holden James R Jr · Milton, GABuilt 1973 · S/N 28-7325588 N5619WIsbell David Myles · Tucson, AZBuilt 1962 · S/N 28-761 N561DEFlynn John M · Martinez, CABuilt 1975 · S/N 17265572 N561FLOnwe Edward E · San Antonio, TXBuilt 1971 · S/N 28-7125402 N561MAMcdonald Jeffrey D · Chilmark, MABuilt 2003 · S/N 2843561 N561MHDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 28-7690264 N561PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842103 N561TPKerner Christine A · Yelm, WABuilt 1988 · S/N 11041C N561ZDelgado-Ocasio Brunilda · Patillas, PRBuilt 1974 · S/N 17263225 N56201Kaney Howard W · West Bend, WIBuilt 1973 · S/N 28-7325590 N56202Kunze Paul C · Tempe, AZBuilt 1973 · S/N 28-7305551 N56204Andreas Charles V · Neenah, WIBuilt 1973 · S/N 28-7305552 N5621QOwens Ronald W · Newburgh, INS/N 3009 N5621UMeinert Kyle L · Cottage Grove, WIBuilt 1969 · S/N 28-26417 N5621WHurt Bret K · Huntsville, ALBuilt 1962 · S/N 28-764 N56220Seashell Aviation LLC · Milton, FLS/N 28-7325591 N56224Thomas Way LLC · Jackson, MIBuilt 1973 · S/N 28-7305554 N56227Registration Pending · Ira, MIRegistration pendingBuilt 1973 · S/N 28-7305555 N5622KAyorinde Olawale T · Upper Marlboro, MDBuilt 1973 · S/N 28-7305556 N56239Hobart Aviation Inc · Akron, OHS/N 28-7325593 N5623EKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N 17271905 N5623GMorris Hancock Flying Club · Morris, MNBuilt 1979 · S/N 17273562 N5623UMendoza Cesar · Anthony, NMBuilt 1969 · S/N 28-26419 N56241Smith Bonny L · Milan, INBuilt 1973 · S/N 28-7305558 N5624GFoothill Aircraft Sales & Service · Upland, CABuilt 1979 · S/N 17273563 N56256Flying Bears Aviation LLC · Wilmington, DEBuilt 1973 · S/N 28-7305559 N5625QFly High Aviation LLC · Margate City, NJBuilt 1965 · S/N 3011 N5625USkorina Air LLC · Walla Walla, WABuilt 1969 · S/N 28-26421 N5626LMw Aviators LLC · Olathe, KSBuilt 1972 · S/N AA5-0226 N5626UFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26423 N5626WMiller Andy · Marana, AZBuilt 1962 · S/N 28-769 N5627FFolger Alfred J · Columbia, SCBuilt 1976 · S/N 28-7715144 N5627UMcelhannon Susan L · Athens, GABuilt 1969 · S/N 28-26422 N5627WSavio Stefan V · Trophy Club, TXBuilt 1962 · S/N 28-772 N56280Briggs Samuel K · Portland, ORBuilt 1973 · S/N 28-7325597 N56281Lewis Nathan Timothy · Hayden, IDS/N 28-7325598

Back to AD 80-04-03 R2