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.

N269AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51530N26BL58d Leasing LLC · Plover, WIBuilt 1976 · S/N 2030N26CHCoastal Air Service Inc · Panama City, FLBuilt 1998 · S/N 53312N26MVTjr Ltd · Excelsior, MNBuilt 1989 · S/N 4052N26NKLsk Leasing LLC · Lewes, DEBuilt 1980 · S/N 3078N26NRGeorgia Department Of Natural Resources · Atlanta, GABuilt 2014 · S/N 54564N26NXRegistered aircraftN-number assigned (import), not yet registeredS/N 54966N26VAVirginia State Police · Richmond, VABuilt 2006 · S/N 53688N2717WSf Leasing LLC · Norfolk, NEBuilt 1990 · S/N 51340N271AEAir Evac Ems Inc · Ofallon, MOBuilt 1990 · S/N 51351N272MJAir Methods LLC · Greenwood Village, COBuilt 2021 · S/N 54960N274AEAir Evac Ems Inc · O Fallon, MOBuilt 1983 · S/N 45762N2751ACollective Aviation Services · Orient, IABuilt 1979 · S/N 2623N2756PChemair Helicopters Inc · Jefferson, WIS/N 2655N27574Ranger Aviation Leasing LLC · Wilmington, DEBuilt 1979 · S/N 2562N275AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51186N2760KTre Aviation Corp · Wilmington, DES/N 2733N2762PSale Reported · Rantoul, KSSale reported, canceledS/N 2711N27694Orlando Aircraft Sales LLC · Orlando, FLS/N 45282N2773RWarren Smith Contracting Inc · Flagstaff, AZS/N 2772N27758Dragonfly Aviation LLC · Saint Ansgar, IABuilt 1979 · S/N 2791N2779RMace Robert C · Queen Creek, AZS/N 2824N277AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51421N277KATwin Cities Aviation Inc · Yuba City, CAS/N 2177N277LSG & G Transporation LLC · Queen Creek, AZBuilt 1978 · S/N 2312N277RLSan Juan Aviation LLC · Wilmington, DEBuilt 1981 · S/N 3277N277TBSierra Flite LLC · Camden, DES/N 51189N278AMAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2013 · S/N 54464N279THT & T Capital Inc · Bangor, MEBuilt 1986 · S/N 51176N27AEAir Evac Ems Inc · O Fallon, MOBuilt 1978 · S/N 45192N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012N27JBCape Gyro Inc · North Chatham, MABuilt 1973 · S/N 1026N27MHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52045N27TKAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1985 · S/N 51138N27UKOrlando Aircraft Sales LLC · Orlando, FLBuilt 1975 · S/N 1871N280LBBell Textron Inc · Fort Worth, TXBuilt 2011 · S/N 54304N281AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51451N282AEOas2 LLC · Orlando, FLBuilt 1991 · S/N 51452N28373Hornet International LLC · Picayune, MSBuilt 1974 · S/N 1496N283BHJohnson Flying Service LLC · Exira, IABuilt 1991 · S/N 51510N283RLMarks Lloyd · Lafayette, LAS/N 45283N283XLThiel Air Care Inc · Chowchilla, CABuilt 1971 · S/N 715N284AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54528N284CAOrgan Mountain Aviation Co LLC · Las Cruces, NMS/N 1578N284SPKentucky State Police · Frankfort, KYBuilt 2005 · S/N 53655N285AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51550N2869FSilver Creek Aviation Services · Fort Worth, TXFirst renewal noticeBuilt 2004 · S/N 53623N286GJambb LLC · La Verne, CABuilt 1996 · S/N 53042N288AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51327N289MSClipper Group LLC · Newport Beach, CABuilt 2025 · S/N 56456
Back to AD 2013-22-21