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.

N5305RWoodman Larry · Nottingham, NHBuilt 1965 · S/N 17252827 N53061Flying Ducks Aviation LLC · Newport, ORBuilt 1978 · S/N 177RG1334 N53073Zahnow Todd · Raub, NDBuilt 1978 · S/N 177RG1337 N5307QSkyway Leasing Inc · Lakeland, FLBuilt 1972 · S/N 15073207 N5307RFabian Brian L · Corcoran, MNBuilt 1965 · S/N 17252829 N53080Isaacs Christopher W · Advance, NCBuilt 1978 · S/N 177RG1340 N53088Sangal Shiddhartha · Annandale, NJBuilt 1978 · S/N 177RG1343 N5308QBig Sky Leasing LLC · Boise, IDBuilt 1972 · S/N 15073208 N5309QSauvageau Daniel W · Roseville, CABuilt 1972 · S/N 15073209 N53103Top Flight Aerial Photography LLC · Georgetown, TXBuilt 1978 · S/N 177RG1347 N53108Prindle Steven G · Seaford, DEBuilt 1978 · S/N 177RG1348 N5314QN5314q LLC · Titusville, FLBuilt 1972 · S/N 15073214 N53152Griffin Bruce H · Trenton, FLBuilt 1978 · S/N 177RG1352 N53158Schoen William R · Madison, CTS/N 177RG1353 N5315QLessig Bruce D · Casper, WYBuilt 1972 · S/N 15073215 N53160Benson Michael H · New Castle, PABuilt 1978 · S/N 177RG1354 N53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeS/N 177RG1357 N5318QProsperous Holdings LLC · Gainesville, GAS/N 15073218 N53194Jagav LLC · Lewes, DEBuilt 1978 · S/N 177RG1360 N5319QPurcell Melinda · Caseyville, ILS/N 15073219 N5319RSchuster Glen N · Sleepy Eye, MNBuilt 1965 · S/N 17252843 N531CPRegistration Pending · Starkville, MSRegistration pendingBuilt 1973 · S/N 15074997 N5323PCarls Phillip G · Frederick, MDBuilt 1972 · S/N 15073223 N5323ROld Grove Aviation LLC · Port Charlotte, FLBuilt 1965 · S/N 17252848 N5325QIlm Aviation LLC · Waxahachie, TXBuilt 1972 · S/N 15073225 N5325RBardo Daniel J · Salem, OHBuilt 1965 · S/N 17252850 N5327QLarsen Deziree L · Bay Point, CABuilt 1972 · S/N 15073227 N5327RMcgrath John J · Littleton, COBuilt 1965 · S/N 17252852 N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855 N5330QBend Aircraft Mechanics LLC · Bend, ORBuilt 1972 · S/N 15073230 N5331RHastings Peter D · Bar Harbor, MEBuilt 1965 · S/N 17252857 N5332RJohnson Michael Hans · Tuttle, NDBuilt 1965 · S/N 17252858 N5333TParkison Leland Cameron · Battle Ground, WABuilt 1967 · S/N 17256100 N5334RDasilva Jonathan L · Madera, CABuilt 1965 · S/N 17252861 N53350Conner Michael J · Scotts Valley, CABuilt 1965 · S/N 17252862 N5336GHyatt Mark A · Colorado Springs, COBuilt 1967 · S/N R172-0154 N5338QFly By Knight LLC · Louisville, KYBuilt 1972 · S/N 15073238 N533KAKamaka Air LLC · Honolulu, HIBuilt 1973 · S/N 20700216 N533TDChristopher Schultheis Inc · Colton, WABuilt 1962 · S/N 18253879 N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871 N5344QGraber Quinten R · Brooksville, MSS/N 15073244 N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872 N5345QRegistered aircraftBuilt 1972 · S/N 15073245 N5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1972 · S/N 15073246 N5349RTroya Aviation LLC · Utica, NYBuilt 1965 · S/N 17252878 N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004 N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109 N5350RNorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N 17252879 N5352RProam Flyers Of Union County · Matthews, NCBuilt 1965 · S/N 17252882 N5353QRegistered aircraftBuilt 1972 · S/N 15073253

Back to AD 72-03-03 R3