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.

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 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 N390PMPlanemasters Ltd · West Chicago, ILBuilt 1990 · S/N UC-110 N39UBAmeriflight LLC · Dallas, TXS/N UB-39 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 N422AXAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-95 N453LCIron Aviation LLC · Bozeman, MTBuilt 1986 · S/N UB53 N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394 N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74 N49UCUas Transervices Inc · Boca Raton, FLBuilt 1989 · S/N UC49 N542AXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-192 N543AXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-219 N575FAlpine Aviation Inc · Provo, UTBuilt 1990 · S/N UC-99 N575GUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-155 N60MJAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-60 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 N655MWMarvin Lumber And Cedar Company · Warroad, MNBuilt 1999 · S/N UE-377 N660MWMarvin Lumber And Cedar Co · Warroad, MNBuilt 1996 · S/N UE-215 N680MWMarvin Lumber And Cedar Co · Warroad, MNBuilt 1999 · S/N UE-362 N68UBAlpine Aviation Inc · Provo, UTS/N UB-68 N690MAAviation Inventory Resources Inc · Alvarado, TXS/N UE-161 N716MJAlpine Aviation Inc · Provo, UTBuilt 1992 · S/N UE-16 N717LCAircraft Capital Partners LLC · Bozeman, MTBuilt 1992 · S/N UE-17 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

Back to AD 97-15-13 R2