OpenAirDocs.org
AD 2008-12-16

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

N101MCMarc Inc · Bolton, MSBuilt 1973 · S/N T234N113MHCasavia Corp · Guelph OntarioBuilt 1980 · S/N T330N117CCEv Advisors LLC · Scottsdale, AZBuilt 1979 · S/N T-325N120TMInterstate Automotive Services Inc · Franklin, TNBuilt 1981 · S/N T-405N12MFMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N T-417N145WFAircraft Propulsion Leasing LLC · Holland, OHBuilt 1993 · S/N DC-824BN152AFUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N AC520N158MCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-726BN158WAHkb Aviation LLC · San Antonio, TXBuilt 1981 · S/N TC411N159MCGas/Wilson Inc · Traverse City, MIS/N AC-728BN175SWDenaina Air Taxi LLC · Anchorage, AKBuilt 1985 · S/N AC 621-BN184SWCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-647N200SNAdvantage Jet Holdings LLC · Chino Hills, CABuilt 1980 · S/N T-354N202WSCorsair Turbines LLC · Georgetown, TXBuilt 1975 · S/N AT037N211RHMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC421BN21GPKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC754BN226KLCbg LLC · Wilsonville, ORBuilt 1979 · S/N TC-321N226XXInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N T245N227LCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-707BN227LECbg LLC · Tualatin, ORBuilt 1993 · S/N DC837BN227LJMetro-Jet LLC · Downey, CABuilt 1982 · S/N AC-522N240DHUas Transervices Inc · Boca Raton, FLS/N AT-602N241DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-607BN244DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-618BN245DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-624BN246DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-625BN248DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-630BN249DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-631BN25677Hometown LLC · Cleburne, TXS/N T-254N2691WCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-655BN26959Bemidji Aviation Services Inc · Bemidji, MNBuilt 1986 · S/N AC-662BN2699YMcneely Charter Service Inc · West Memphis, ARBuilt 1986 · S/N AC-666N2728GCbg LLC · Wilsonville, ORBuilt 1989 · S/N AC-731N27442Mission Flight · El Monte, CABuilt 1989 · S/N AC750-BN276CACbg LLC · Wilsonville, ORBuilt 1978 · S/N TC276N279ML And L Investment LLC · Wilmington, DES/N T279N280KLCbg LLC · Wilsonville, ORBuilt 1978 · S/N TC-280N303MAHutchison Aviation LLC · Alpharetta, GAS/N T278N307PATgf Aviation LLC · Lafayette, LAS/N T307N3108BGas Wilson Inc · Traverse City, MIS/N AC509N3114GM E S LLC · Anchorage, AKBuilt 1984 · S/N AC-583N3116NBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N AC-596N31171Cbg LLC · Wilsonville, ORBuilt 1985 · S/N AC-605N320MCMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC688N326BACbg LLC · Wilsonville, ORBuilt 1978 · S/N TC 269N329HSFlying Piggs LLC · Klamath Falls, ORBuilt 1979 · S/N T-323N336GWWorld Class Aviation Inc · Peachtree City, GABuilt 1994 · S/N DC860MN339GWWorld Class Aviation Inc · Peachtree City, GAS/N DC-791MN339RWMy Shovel LLC · Jackson, MSS/N T339N3531QNew Mountain Aviation LLC · Englewood, COBuilt 1990 · S/N AC-767B
Back to AD 2008-12-16