Skip to content

Registered aircraft · 157

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-15-13-R2') 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-15-13-R2') 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-15-13-R2')
    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-15-13-R2')
  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-15-13-R2')
  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-15-13-R2')
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.

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 N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1 N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66 N191AWCsi 135 Division LLC · Albuquerque, NMBuilt 1996 · S/N UE-251 N191CSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N UE-392 N191CZPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB-59 N192GAAlpine Aviation Inc · Provo, UTS/N UB-17 N193CZPlanemasters Ltd · West Chicago, ILBuilt 1989 · S/N UC-73 N194GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-8 N195AWCsi 135 Division LLC · Albuquerque, NMBuilt 1993 · S/N UE-128 N195GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-195 N197GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-16 N198AWCsi Aviation Inc · Albuquerque, NMBuilt 1997 · S/N UE293 N198GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-5 N19EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N UE326 N19RZUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC-75 N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201 N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202 N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164 N20RADepartment Of The Air Force · Hill Afb, UTBuilt 1985 · S/N UB-42 N211GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-211 N218SLAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC113 N219RMMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1988 · S/N UC-13 N219VPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-14 N21RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-106 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 N241AXTailwind Investments LLC · Anchorage, AKBuilt 1988 · S/N UC-24 N242AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-72 N244AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-78 N245AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-83 N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245 N246AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-114 N247AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-136 N247GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-247 N248AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-154 N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160 N253GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-253 N253SFAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC53 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 N26RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-134 N270ACAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC-174 N290PMPlanemasters Ltd · West Chicago, ILBuilt 1987 · S/N UB71

Back to AD 97-15-13 R2