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.

N33RNMurphey John L · Fredericksburg, VABuilt 1964 · S/N 21058533 N33SQJohnston H Kenneth II · Wheatland, WYBuilt 1966 · S/N T210-0056 N34005Hinckley David D · Belton, TXFirst renewal noticeBuilt 1970 · S/N 17701590 N3400FSpencer Aviation Services LLC · Sanger, TXBuilt 1966 · S/N 18257400 N34011Cross Charles W Jr · Willoughby, OHBuilt 1970 · S/N 17701594 N34012Cap Flyers Aero Club LLC · Ocala, FLBuilt 1970 · S/N 17701595 N34014Rupp Gregory J · Deltona, FLBuilt 1976 · S/N 177RG0949 N34015Leftwich Brian · Savannah, GABuilt 1970 · S/N 17701597 N34019Kortum Ronald L · Williamstown, NJBuilt 1970 · S/N 17701599 N3401SSonntag Robert Dennis · Volant, PABuilt 1964 · S/N 18255801 N34029Rigdon William K · Hazel Green, WIBuilt 1970 · S/N 17701605 N3402FTran Dzung V · Las Vegas, NVS/N 18257402 N3402RBurton Darrell · Somerset, KYBuilt 1968 · S/N 18258702 N34030Sommer Greg J · Maryville, ILBuilt 1976 · S/N 177RG0953 N34038B&B Cardinal LLC · Alexandria, VABuilt 1970 · S/N 17701608 N34039Snedeker Andrew · Jackson, NJBuilt 1976 · S/N 177RG0954 N3403ULintvedt Brian · Presho, SDBuilt 1963 · S/N 18254803 N34041Lange Charles A · Portageville, MOBuilt 1970 · S/N 17701610 N34043Wrg Flyers LLC · Denver, COBuilt 1970 · S/N 17701611 N34045Ackerman Mark R · Box Elder, SDBuilt 1970 · S/N 17701612 N34049Osetek James · Harbor Springs, MIBuilt 1971 · S/N 17701616 N3404FJones Jimmy N · Bremond, TXS/N 18257404 N3404RHuffstetler Don · Mount Vernon, TXBuilt 1967 · S/N 18258704 N3404THaik Kevin Jerome · Ozark, MOS/N 17700704 N34052Bauerle William L · Imperial, NEBuilt 1971 · S/N 17701617 N34058Dodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 177RG0956 N3405FGo Up High LLC · Grafton, WIBuilt 1967 · S/N 17700602 N3405JRichmond Consulting LLC · Blanding, UTS/N 15066105 N3405SStutz Aaron M · Weed, CABuilt 1964 · S/N 18255805 N34063Sherman Stephen P · Prattville, ALBuilt 1976 · S/N 177RG0957 N34064Kupka John J · Okeechobee, FLBuilt 1971 · S/N 17701622 N3406JScholle Joseph E · Mustang, OKBuilt 1967 · S/N 15066106 N34072Baden Aviation LLC · North Royalton, OHBuilt 1976 · S/N 177RG0960 N34077Registration Pending · Santa Monica, CARegistration pendingBuilt 1976 · S/N 177RG0961 N3407FHoltzinger Tyler · Muscle Shoals, ALBuilt 1966 · S/N 18257407 N3407LRoadarmel Brandon · Bozeman, MTBuilt 1966 · S/N U206-0707 N3407SWeaver Jason Andrew · Germantown, TNBuilt 1964 · S/N 18255807 N3407UNote Clayton Rex · Eagle Point, ORBuilt 1963 · S/N 18254807 N34080Rodell Justin A · Saint Paul, MNBuilt 1976 · S/N 177RG0963 N34081Danko James A · Norton, OHS/N 177RG0964 N34084Cardinal Aviation LLC · Eureka, MOBuilt 1976 · S/N 177RG0965 N3408RFronapfel Hannah A · Palmer, AKBuilt 1967 · S/N 18258708 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708 N34096Mirafuentes Akoni Jr · Surprise, AZBuilt 1976 · S/N 177RG0970 N34097Brennan Benjamin M · Pensacola, FLBuilt 1971 · S/N 17701638 N34099Nehrbass Daniel · Santa Ana, CABuilt 1971 · S/N 17701639 N3409JMountain Home Oasis LLC · Albuquerque, NMBuilt 1967 · S/N 15066109 N3409RAnderson Curtiss B · Heber Springs, ARBuilt 1968 · S/N 18258709 N34101Aldrich Andrew J · Soulsbyville, CABuilt 1971 · S/N 17701641 N34102Jaquez Marlene D · Baton Rouge, LABuilt 1971 · S/N 17701642

Back to AD 72-03-03 R3