OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,381

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

N317Magic Carpet Aviation LLC · San Antonio, TXBuilt 1993 · S/N 52014N3172COlson Marine Inc · Ward Cove, AKS/N 3669N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648N317JPTomlinson Aviation Inc · Ormond Beach, FLBuilt 2002 · S/N 4563N3180LGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 51055N3184PMarks Lloyd · Lafayette, LAS/N 45774N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778N3188ZFulton County Police Headquarters · Atlanta, GABuilt 1985 · S/N 3860N318AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51160N318RLOcean Air Helicopters Inc · Port Orford, ORBuilt 2005 · S/N 52318N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779N3191Gm Leasing Co LLC · Broussard, LABuilt 1997 · S/N 53211N3192G3192 Golf Inc · Wauchula, FLBuilt 1972 · S/N 809N3196GUSA Helicopter Inc · West Winfield, NYBuilt 1972 · S/N 775N319AEAir Evac Ems Inc · O Fallon, MOS/N 52040N319MHMaritime Helicopters Inc · Homer, AKBuilt 1997 · S/N 53153N319MWSan Diego County Sheriff Department · El Cajon, CABuilt 2019 · S/N 54841N31ATHelicopter Leasing Inc · Coral Gables, FLBuilt 1972 · S/N 918N3202DPapa Mike Aviation LLC · Dousman, WIBuilt 1985 · S/N 3849N3202QDavid Lee Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1986 · S/N 3938N320CMDyvig Enteprises LLC · Northwood, IABuilt 1972 · S/N 836N3211NTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1984 · S/N 3808N321AHBektor III LLC · Kalispell, MTBuilt 1984 · S/N 51100N321AWBolin William E · Smithville, OHBuilt 1967 · S/N 82N322ECDivesa Aviation Services LLC · Missoula, MTBuilt 1977 · S/N 2218N322NBlue Sky LLC · Anchorage, AKS/N 1507N324CMClarke Environmental Mosquito Management · Roselle, ILBuilt 1977 · S/N 2303N325AEAir Evac Ems Inc · O Fallon, MOBuilt 1993 · S/N 52009N325MHMaritime Helicopters Inc · Homer, AKBuilt 2002 · S/N 53544N327AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51365N32AEAir Evac Ems Inc · O Fallon, MOBuilt 1979 · S/N 45327N32DJKeybank Na Its Division Key Equipment Finance · Superior, COBuilt 2022 · S/N 56325N32KYEnglish Air Service LLC · Santa Maria, CABuilt 1979 · S/N 2875N330BCBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53717N331MHKt Auburndale LLC · Panama City Beach, FLBuilt 1982 · S/N 3564N332MHXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2958N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203N333FCGolden Ranch Aviation Inc · Raceland, LABuilt 1975 · S/N 1763N333LWBohica Consulting Service Of Nevada Inc · Boulder City, NVBuilt 1980 · S/N 2932N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326N334KCHawk Hollow Farm LLC · Brighton, MIBuilt 1994 · S/N 4303N335DMSmith Steven Lee · Whitehall, MTBuilt 1981 · S/N 3330N336AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52436N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383N338AEGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52087N338AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54638N338JD22t Aero LLC · Anchorage, AKBuilt 2021 · S/N 54983N3399Scotts Helicopter Service · Le Sueur, MNBuilt 1968 · S/N 305N33HFHalo-Flight Inc · Corpus Christi, TXBuilt 2015 · S/N 54567
Back to AD 2013-22-21