AD 2014-06-01

Registered aircraft · 180

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
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:2014-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-06-01')
  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.

N542FACbg LLC · Wilsonville, ORS/N AC-542N5441MBas Part Sales LLC · Greeley, COBuilt 1977 · S/N T-283N544UPUas Transervices Inc · Boca Raton, FLS/N AT-544N548UPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N AT-548N54GPCastle Aviation Inc · North Canton, OHBuilt 1975 · S/N AT034N55CEUnited States Army Corps Of Engineers · Omaha, NEBuilt 2000 · S/N DC-903BN560UPUas Transervices Inc · Boca Raton, FLS/N AT-560N561UPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N AT-561N563TRKolob Canyons Air Services Inc · Wilmington, DES/N AT563N564TRCareer Aviation Co · Wilmington, DES/N AT564N567TRCareer Aviation Co · Wilmington, DES/N AT567N571KLCbg LLC · Wilsonville, ORS/N AC-571N572GWGas/Wilson Inc · Traverse City, MIS/N AC-572N573GUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N AT-446BN578AFUas Transervices Inc · Boca Raton, FLS/N AC-578N5LNM7 Aviation Services LLC · Houston, TXBuilt 1995 · S/N DC878BN6105LWorld Class Aviation Inc · Peachtree City, GAS/N DC-831MN611BABemidji Aviation Services Inc · Bemidji, MNBuilt 1985 · S/N AC611BN611RHMcneely Charter Service Inc · West Memphis, ARBuilt 1981 · S/N AT423N616PSDena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1979 · S/N T316N619BABemidji Aviation Services Inc · Bemidji, MNBuilt 1985 · S/N AC619BN63NECareer Aviation Company Inc · Wilmington, DES/N AC763BN649KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC-649N652KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1986 · S/N AC-652BN654ARMcneely Charter Service Inc · West Memphis, ARBuilt 1994 · S/N DC868BN660EAGas/Wilson Inc · Traverse City, MIBuilt 1986 · S/N AC-660BN671AVUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC671N672AVUas Transervices Inc · Boca Raton, FLS/N AC672N673AVUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N AC673N680MDKolob Canyons Air Services Inc · Wilmington, DEBuilt 1991 · S/N AC776BN681TRSierra West Airlines Inc · Wilmington, DEBuilt 1987 · S/N AC682N685BARed Pine Company LLC · Bemidji, MNBuilt 1987 · S/N AC-685BN690WWBemidji Aviation Services Inc · Bemidji, MNBuilt 1987 · S/N AC690BN691AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N AC-691N699KMMerlin Cattle Co LLC · El Paso, TXBuilt 1975 · S/N T256N699RKDynamic Aircraft Consortium LLC · Tangent, ORBuilt 1979 · S/N T300N709TRAmeriflight LLC · Dfw Airport, TXS/N AC-709BN727DPTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTS/N AT039N731TFTwo Friends Leasing LLC · Key West, FLBuilt 1979 · S/N T321N733BHCareer Aviation Company Inc · Wilmington, DEBuilt 1989 · S/N AC-733BN73HCYaw Nix LLC · Shreveport, LABuilt 1969 · S/N T26-138N746KAKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC 746 BN749LGeco Inc · Wilmington, DES/N T306N751TRCareer Aviation Company Inc · Wilmington, DEBuilt 1989 · S/N AC751BN753TRCareer Aviation Co Inc · Wilmington, DEBuilt 1989 · S/N AC753BN75MXNational Test Pilot School · Mojave, CAS/N T-218N762VM5-T Aviation LLC · Eunice, LABuilt 1987 · S/N AT-695BN763LDBadil-Abish Thomasena · Spring, TXBuilt 1979 · S/N T-313N769KLCbg LLC · Wilsonville, ORBuilt 1991 · S/N AC769BN770TRCareer Aviation Co · Wilmington, DEBuilt 1991 · S/N BC-770B
Back to AD 2014-06-01