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') 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') 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')
    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')
  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')
  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')
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 N100VGMarmentini Rosecler Catuzzo · Houston, TXS/N UC92 N101UEAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-101 N103SFAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-103 N105EV2nd Amendment Wholesale Inc · Grand Forks, NDS/N UE-64 N110AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC-93 N111AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-81 N111YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-111 N112YVUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC112 N113AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-41 N114AXAlpine Aviation Inc · Provo, UTBuilt 1988 · S/N UC-36 N115AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-2 N117AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC-79 N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114 N118AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC116 N119AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC-43 N120UCAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC120 N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122 N124AXAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC158 N124GPAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-23 N125AXAlaska Central Express Inc · Anchorage, AKBuilt 1988 · S/N UC44 N125BAAlpine Aviation Inc · Provo, UTS/N UB-6 N126AXAlaska Central Express Inc · Anchorage, AKBuilt 1990 · S/N UC-140 N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76 N127BAAlpine Aviation Inc · Provo, UTS/N UB-7 N128AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC68 N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229 N130SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-130 N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131 N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132 N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N150KJAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-150 N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N155CJUe-55 LLC · Helena, MTS/N UE-55 N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58 N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157 N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159 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 N172GAAlpine Aviation Inc · Provo, UTS/N UB-11 N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176 N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178

Back to AD 97-15-13