Skip to content

Registered aircraft · 17,027

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

N2078RCustom Aviation LLC · Butler, PABuilt 1964 · S/N 18255278 N2079QMkk Pilots LLC · Media, PABuilt 1974 · S/N 177RG0479 N207CHAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 20700039 N207CZBig Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 20700355 N207DDHillyard Robert Keith · Dallas, TXBuilt 1969 · S/N 20700049 N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070 N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091 N207GMWaters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 20700217 N207JUnwrapped LLC · Dover, DEBuilt 1965 · S/N P206-0086 N207JPWaters Aero-Marine Inc · Owls Head, MEBuilt 1974 · S/N 20700255 N207JVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0121 N207NNCasaccio Paul E · Beesleys Point, NJBuilt 1969 · S/N 20700040 N207PAMcnutt Ross T · Xenia, OHBuilt 1970 · S/N 20700162 N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311 N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647 N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280 N2083QCardinal N2083q LLC · Churchville, PABuilt 1974 · S/N 177RG0483 N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283 N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284 N2084XPrier Duncan M · Bonita Springs, FLBuilt 1965 · S/N 18256184 N2085XBrian Murray J · Pekin, ILBuilt 1965 · S/N 18256185 N2086QMillner Paul · Berkeley, CABuilt 1974 · S/N 177RG0486 N2086XPerron Joseph R · Jasper, GABuilt 1965 · S/N 18256186 N2087RMangus Ricky Alan · Kent, WABuilt 1964 · S/N 18255287 N2088RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N 18255288 N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489 N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189 N208KCAcevedo Adriel · San Antonio, TXS/N 15070435 N2090QRawls Mike E · New Waverly, TXS/N 177RG0490 N2090XTreeline Services LLC · Grimes, IAS/N 18256190 N2090YKilbey Bryan E DBA · Defuniak Springs, FLS/N 177RG1106 N2091QJohnson Earl V · Andalusia, ALBuilt 1974 · S/N 177RG0491 N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191 N2095RTyson John H · Melba, IDS/N 18255295 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N209TOnele Dennis E · Central City, NES/N 15068531 N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596 N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888 N20AXHehmann Richard J · Belleville, ILS/N 177RG1160 N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N2100FDurocher David T · Fernley, NVBuilt 1965 · S/N U206-0301 N2100RAbresch Craig G · Idaho Falls, IDBuilt 1964 · S/N 18255300 N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785

Back to AD 72-03-03 R3