Skip to content

Registered aircraft · 95

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:85-21-07-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:85-21-07-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:85-21-07-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:85-21-07-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:85-21-07-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:85-21-07-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.

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 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 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 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 N130SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-130 N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131 N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54 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 N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25 N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58 N159SFSuburban Air Freight Inc · Omaha, NEBuilt 1991 · S/N UC-159 N172GAAlpine Aviation Inc · Provo, UTS/N UB-11 N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1 N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66 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 N197GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-16 N198GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-5 N19RZUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC-75 N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164 N20RADepartment Of The Air Force · Hill Afb, UTBuilt 1985 · S/N UB-42 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 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

Back to AD 85-21-07 R1