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.

N34729Registered aircraftBuilt 1973 · S/N 17701964 N3472FMiller Robert F · Locust Grove, GAS/N 18257472 N34731Edenhoffer Peter J · Paris, TXBuilt 1973 · S/N 17701965 N34732Kohles Terrance · Portsmouth, IABuilt 1973 · S/N 17701966 N34735Stramer Todd Personal Representative · Hazelton, NDBuilt 1973 · S/N 17701968 N34737Seareylife LLC · Orlando, FLBuilt 1973 · S/N 17701969 N34739Flying Pterodactyl LLC · Sarasota, FLBuilt 1973 · S/N 17701971 N3473FBoone Bruce L · Woodland, CAS/N 18257473 N3473RBrooks Gregory Keith · Green Cove Springs, FLBuilt 1967 · S/N 18258773 N34743Rogers Ronald · Olney, TXFirst renewal noticeBuilt 1973 · S/N 17701972 N34749Hardy Camden L · Seattle, WABuilt 1973 · S/N 17701975 N347513218t Inc · Omaha, NEBuilt 1973 · S/N 17701977 N34753Vanhook Enterprises Inc · West Somerset, KYBuilt 1973 · S/N 17701979 N34756Devereaux Christopher L · Raleigh, NCBuilt 1973 · S/N 17701982 N34757James David C · Redlands, CABuilt 1973 · S/N 17701983 N34758Vaccaro Glen J · Trinidad, COBuilt 1973 · S/N 17701984 N34759Steckbeck Richard James · Enid, OKBuilt 1973 · S/N 17701985 N3475FSanguinetti Mark · Winnsboro, LAS/N 18257475 N3475RMccullough Hugh J · Glennville, GABuilt 1968 · S/N 18258775 N3475SSmith Reine K IV · Lockhart, TXBuilt 1965 · S/N 18255875 N3475TWitt Jerry D · Marana, AZBuilt 1968 · S/N 17700775 N34760Abrahamson Allen G · Frisco, TXBuilt 1973 · S/N 17701986 N34761Griffin Jeremiah L · Titus, ALBuilt 1973 · S/N 17701987 N34762Cadamore Brian S · Cabot, PABuilt 1973 · S/N 17701988 N34764York Aviators LLC · York, PABuilt 1973 · S/N 17701990 N34766Robbins Paul A · Nacogdoches, TXS/N 17701991 N34767Tschida Thomas R · Mendota Heights, MNBuilt 1973 · S/N 17701992 N3476FDickens Charles L · Panama City Beach, FLS/N 18257476 N3476JJr Imaging Logistics Inc · Pasco, WAS/N 15066176 N3476RTibbs Properties LLC · Franklin, LABuilt 1968 · S/N 18258776 N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876 N34770Gustin Brian K · Camdenton, MOBuilt 1973 · S/N 17701994 N34772Mlaskoch Air LLC · Willow River, MNBuilt 1973 · S/N 17701996 N34774Dunn Gregory Scott · Wooster, OHBuilt 1973 · S/N 17701998 N34777Trautmann Glenn K · Highlands Ranch, COBuilt 1973 · S/N 17702000 N3477FFlying T LLC · Albuquerque, NMBuilt 1966 · S/N 18257477 N3477SN3477s Inc · Dalton Gardens, IDS/N 18255877 N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003 N3478TGuzowski Richard G · Haydenville, MABuilt 1968 · S/N 17700778 N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005 N34795Fox Business Advisors LLC · Mesa, AZBuilt 1974 · S/N 17702006 N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007 N3479RM S Davidson Enterpries Pc · Laurel, DEBuilt 1968 · S/N 18258779 N3479SCook Mark C · Hutto, TXBuilt 1964 · S/N 18255879 N3479TRobbins Derick Mitchell Robbins · Freeport, FLBuilt 1968 · S/N 17700779 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N34807Wiese Marcus G · Shady Shores, TXBuilt 1976 · S/N 177RG1014 N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016 N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017 N3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeBuilt 1966 · S/N 18257480

Back to AD 72-03-03 R3