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.

N6947PHudzinski Joel David · Newaygo, MIBuilt 1960 · S/N 24-2082 N6948C48 Charlie LLC · Columbia, MDS/N 28R-7837177 N6948PBernard David J · Paris, OHS/N 24-2083 N6949PDepew Kevin I · Everett, WABuilt 1960 · S/N 24-2084 N694APCook Christopher W · Indian Mound, TNS/N 24-1147 N6950PRegistered aircraftBuilt 1960 · S/N 24-2085 N6951PRossback Jason M · Denver, COBuilt 1960 · S/N 24-2086 N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178 N6952JLagimoniere Gregory · Jacksonville Beach, FLBuilt 1976 · S/N 28R-7635365 N6952PBretts Flying Service LLC · Mount Pleasant, MIS/N 24-2087 N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393 N6953PCianciolo Philip H · Yakima, WABuilt 1961 · S/N 24-2088 N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394 N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090 N6959PSteamboat Express LLC · Sheridan, WYBuilt 1960 · S/N 24-2097 N6961JBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680395 N6962PSteyn Glen D · Marietta, OHBuilt 1960 · S/N 24-2100 N6964PEvans Phillip R · Dinuba, CABuilt 1960 · S/N 24-2104 N6968PFoos LLC · Vancouver, WABuilt 1960 · S/N 24-2109 N6969PHart Richard W · Alexandria, VABuilt 1960 · S/N 24-2111 N696JGTaylor Workforce Housing LLC · Wichita Falls, TXS/N 34-8070065 N696PGreer James E Jr · Summit Point, WVBuilt 1960 · S/N 24-1718 N6973JStracener Adam · Pittsburg, TXBuilt 1976 · S/N 28R-7635369 N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116 N6978PGallego Victor · Matawan, NJBuilt 1960 · S/N 24-2121 N697FTSilvey Michael Duane · Newhall, CABuilt 1973 · S/N 28R-7335140 N697JBDaccarett Marcos · Boise, IDBuilt 1976 · S/N 34-7770035 N6981PShakis Bear LLC · O Neill, NEBuilt 1960 · S/N 24-2124 N6982PCapuano Group Inc · Ormond Beach, FLBuilt 1960 · S/N 24-2125 N6983JLaid Back Investment Holdings LLC · Cairo, GABuilt 1976 · S/N 28R-7635371 N6983PRegistration Pending · Branchburg, NJRegistration pendingBuilt 1960 · S/N 24-2126 N6984PEnglish John H · Pittsburg, TXBuilt 1960 · S/N 24-2127 N6985JAvel Aircraft Inc · West Chicago, ILBuilt 1976 · S/N 34-7670309 N6985PDull Stephen A · Redkey, INBuilt 1960 · S/N 24-2128 N6988PKubitz Wesley M · Laurel, MTBuilt 1960 · S/N 24-2131 N6994PHunt Ray A · Louisburg, NCBuilt 1960 · S/N 24-2137 N6995CDetert Bradley · Valparaiso, INBuilt 1978 · S/N 28R-7837180 N6995PInternational Air Services Inc Trustee · Carson City, NVBuilt 1960 · S/N PA-24-2138 N6996PWelling Charles E III · West Islip, NYBuilt 1960 · S/N 24-2139 N6998NPacifica LLC · Grand Junction, COS/N 28R-35797 N6999JSun West Aviation Inc · Santa Ynez, CABuilt 1976 · S/N 28R-7635373 N69FMAirtime LLC · South Lyon, MIBuilt 1976 · S/N 32R-7680200 N69GSDaphnee Moise Md Pa · Sarasota, FLBuilt 1972 · S/N 28R-7235275 N69LHGraham Jack · Hamilton, TXBuilt 1977 · S/N 32R-7780323 N69MWOlson James H · Eleva, WIBuilt 1975 · S/N 28R-7635064 N69PAWanagel Joshua · Berwyn, PABuilt 1969 · S/N 28R-35159 N69PDDemray William S · Northville, MIBuilt 1960 · S/N 24-1377 N69PSHawkeye Holding Company LLC · Robins, IABuilt 1976 · S/N 34-7770056 N69RDKrens Janet E · Purcellville, VABuilt 1963 · S/N 30-183 N6ECDraco Flight School Inc · Chino, CABuilt 1974 · S/N 28R-7435220

Back to AD 97-01-01 R1