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.

N245AXTailwind Investments LLC · Anchorage, AKBuilt 1989 · S/N UC-83 N246AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-114 N247AXTailwind Investments LLC · Anchorage, AKBuilt 1990 · S/N UC-136 N248AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-154 N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160 N253SFAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC53 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 N3052KUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N UB-70 N3071AUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-46 N31701Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-2 N31702Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-3 N31703Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-10 N31704Uas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N UB-12 N31705Uas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N UB-60 N324SAAtlantic Air Services 71991 Inc · Largo, MDBuilt 1989 · S/N UC-94 N330AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-38 N331AFUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-44 N332LCUc132 LLC · Dallas, TXS/N UC132 N338AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC57 N346AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC71 N347AFAmeriflight LLC · Dallas, TXBuilt 1989 · S/N UC66 N34RZUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-151 N367SFSuburban Air Freight Inc · Omaha, NEBuilt 1989 · S/N UC-67 N390PMPlanemasters Ltd · West Chicago, ILBuilt 1990 · S/N UC-110 N39UBAmeriflight LLC · Dallas, TXS/N UB-39 N422AXAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-95 N453LCIron Aviation LLC · Bozeman, MTBuilt 1986 · S/N UB53 N49UCUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC49 N575FAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-99 N575GUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-155 N60UCAlpine Aviation Inc · Provo, UTS/N UC-60 N61UCAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC61 N640AXAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N UC-1 N64UCAlpine Aviation Inc · Provo, UTS/N UC-64 N68UBAlpine Aviation Inc · Provo, UTS/N UB-68 N718AFUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-162 N719GLAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-19 N7203CUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N UB-28 N806JGGallagher James · Thornhurst, PABuilt 1989 · S/N UC63 N821SFAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-121 N900MXTropical Transport Services Ltd Inc · San Juan, PRBuilt 1986 · S/N UB-55 N970EATailwind Investments LLC · Anchorage, AKS/N UC-100 N984ABSunbird Airlines Inc · San Juan, PRBuilt 1989 · S/N UC-84

Back to AD 85-21-07 R1