Skip to content

Registered aircraft · 62

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-03-01') 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-03-01') 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-03-01')
    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-03-01')
  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-03-01')
  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-03-01')
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.

N100UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-100 N105EV2nd Amendment Wholesale Inc · Grand Forks, NDS/N UE-64 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122 N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N155CJUe-55 LLC · Helena, MTS/N UE-55 N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157 N15GABering Air Inc · Nome, AKS/N UE37 N165YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-165 N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169 N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170 N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71 N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176 N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178 N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184 N1902DBoeing Co · Berkeley, MOBuilt 1998 · S/N UE327 N190AWCsi 135 Division LLC · Albuquerque, NMBuilt 1999 · S/N UE-382 N191AWCsi 135 Division LLC · Albuquerque, NMBuilt 1996 · S/N UE-251 N191CSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N UE-392 N195AWCsi 135 Division LLC · Albuquerque, NMBuilt 1993 · S/N UE-128 N195GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-195 N198AWCsi Aviation Inc · Albuquerque, NMBuilt 1997 · S/N UE293 N19EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N UE326 N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201 N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202 N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211 N220GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-220 N22889Tenax Aviation LLC · Ridgeland, MSBuilt 1998 · S/N UE-314 N231YVAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-231 N240GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-240 N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245 N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247 N253GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-253 N255GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-255 N257GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-257 N258AWCobra Aviation Services LLC · Oklahoma City, OKBuilt 1996 · S/N UE258 N261GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-261 N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378 N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383 N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158 N408SNUS Department Of State · Melbourne, FLS/N UE-408 N418LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-118 N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422 N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394 N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74 N542AXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-192

Back to AD 97-03-01