Skip to content

Registered aircraft · 6,916

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

N9329NWang Huafei · Cupertino, CABuilt 1969 · S/N 28R-35029 N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827 N9331PAmra Nabil · Chaska, MNS/N 24-4829 N9332NSloan Donald W · Dover, DEFirst renewal noticeBuilt 1969 · S/N 28R-35032 N9333KOrlandi Properties LLC · Blairstown, NJBuilt 1976 · S/N 34-7670198 N9333NGlendale Community College · Glendale, CABuilt 1969 · S/N 28R-35033 N9333PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 24-4831 N9334NRoberson Ronald M · High Ridge, MOBuilt 1969 · S/N 28R-35040 N9337NHoward Robert L · Jacksonville, NCBuilt 1969 · S/N 28R-35037 N9337PWesterfield John III · Birmingham, ALBuilt 1969 · S/N 24-4835 N9338NForker Thomas S · Williamsport, PABuilt 1969 · S/N 28R-35038 N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836 N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837 N9340N9340n LLC · Broken Arrow, OKBuilt 1969 · S/N 28R-35041 N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840 N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843 N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844 N9347NDavis Braeden L · Blanchard, OKBuilt 1969 · S/N 28R-35048 N9347PRegistered aircraftBuilt 1969 · S/N 24-4846 N9348NPletcher Gayle L · Topeka, KSBuilt 1969 · S/N 28R-35049 N9349NStutzman Gary A · Watsontown, PAS/N 28R-35050 N934SBLac Aero LLC · Liberal, KSBuilt 1978 · S/N 34-7970061 N9350KPanjab Aviation · Las Vegas, NVBuilt 1976 · S/N 28R-7635233 N9351NHess Garrett J · Fullerton, CABuilt 1969 · S/N 28R-35054 N9353PSmith Evan B · Mechanicsville, VABuilt 1969 · S/N 24-4854 N9354NThurnau Daniel E · Kingston, ILBuilt 1969 · S/N 28R-35058 N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856 N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033 N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858 N9359NMorristown Flying Service Inc · Talbott, TNBuilt 1969 · S/N 28R-35066 N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859 N9362CThanheiser Heige · Lincoln, NEBuilt 1978 · S/N 28R-7837193 N9362NPool Busters LLC · Lake Bluff, ILBuilt 1969 · S/N 28R-35069 N9363NWeiman William R · Howell, MIBuilt 1969 · S/N 28R-35070 N9364PTougas William E · Timberlake, NCBuilt 1969 · S/N 24-4864 N9368NSocal Resorts LLC · Big Bear Lake, CABuilt 1969 · S/N 28R-35076 N9369PLoadstone Aviation LLC · Billings, MTBuilt 1969 · S/N 24-4869 N936RGrandinetti Robert L · Fayetteville, NYBuilt 1967 · S/N 30-1580 N9370NWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 28R-35078 N9371NTial Aviation Inc · Wilmington, DEBuilt 1969 · S/N 28R-35079 N9371PBuschmann Robert O Jr Trustee · Prescott, AZBuilt 1969 · S/N 24-4871 N9372NAndys Auto Sales LLC · Caroline, WIBuilt 1969 · S/N 28R-35080 N9372PBeery Milo A · Clarinda, IABuilt 1969 · S/N 24-4872 N9373NNelson Charles D · Wibaux, MTS/N 28R-35081 N9373PLeff Benjamin Franklin · Cedar Park, TXBuilt 1969 · S/N 24-4873 N9375NProffitt Albert E III · Warwick, RIBuilt 1969 · S/N 28R-35084 N9377CLiggett Services Inc · Fort Washington, PABuilt 1978 · S/N 28R-7837195 N9379NWinick Evan · Allentown, PABuilt 1969 · S/N 28R-35088 N9379PAerodata Inc · Edgewater, MDBuilt 1969 · S/N 24-4880 N937DCCaledonian Aviation LLC · Raleigh, NCBuilt 1976 · S/N 28R-7635180

Back to AD 97-01-01 R1