OpenAirDocs.org
AD 46-24-01

Registered aircraft · 1,530

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:46-24-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:46-24-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.

N10053Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1943 · S/N 75-4986N1028CCourtney Brent C · Magnolia, TXBuilt 1941 · S/N 75-2051N1029PPrevost Christopher · Sonoma, CAS/N 75-813N1042MDusters And Sprayers Supply Inc · Chickasha, OKS/N 75-7136N1046MStoos Robert A · Lakeland, FLBuilt 1943 · S/N 75-7204N1048MMccullough Carol Charlene Trustee · Tulsa, OKBuilt 1942 · S/N 75-6669N104HAir Cav Helicopters LLC · Wilmington, DES/N 75-2820N10571Carpenter William R · Pocatello, IDS/N 75-1219N10583Minor James F · Lake Dallas, TXBuilt 1946 · S/N 75-7029N10584Manley John A III · Remus, MIS/N 75-5918N1066MN1066m LLC · Vero Beach, FLBuilt 1942 · S/N 75-7932N1066NSmith Fane S · Newport Beach, CAS/N 75-5293N1067NRuby Begonia LLC · Whitefish, MTS/N 75-5313N1068NTravis Brent N · Hayden Lake, IDBuilt 1943 · S/N 75-5364N1074NRare Aircraft Ltd · Faribault, MNBuilt 1942 · S/N 75-5807N107PRDownwind Flight LLC · San Antonio, TXBuilt 1941 · S/N 75-829N109WAGillaspie Terry Hart · Huntsville, TXBuilt 1944 · S/N 75-5484N10DNAdams Harry J · New Waverly, TXBuilt 1949 · S/N 75-5410N10KPDexter Fred H · Live Oak, FLBuilt 1942 · S/N 755247N10LFRossi Severin A · Cossonay VaudBuilt 1942 · S/N 75-5458N10QHammerle Tye F · Kenosha, WIBuilt 1940 · S/N 75-301N1111Johnson Lawrence F · Colville, WABuilt 1942 · S/N 75-4684N1137NHawke Ag Aviation Inc · Oakdale, CABuilt 1942 · S/N 75-5336N1142NTobin Lawrence F · Spokane, WABuilt 1942 · S/N 75-3409N1153NLock Robert A · Lakeland, FLS/N 75-675N1177Kma LLC · New Port Richey, FLBuilt 1942 · S/N 75-5046N117RVAero Rents Inc · Germantown, TNS/N 75-7232N1193NPalm Springs Air Museum · Palm Springs, CABuilt 1941 · S/N 75-1218N11ZWFeltis Alan J · Houston, TXBuilt 1950 · S/N 75-5436N1203MHeritage Aviation LLC · Shannon, ILBuilt 1943 · S/N 75-8167N1207Cavanaugh Air LLC · Addison, TXBuilt 1940 · S/N 75207N1222NMotor Connection Inc · Inglewood, CABuilt 1942 · S/N 75-6782N122BHRay Jimmy · Southlake, TXS/N 75-3858N122QStoltzfus Sandra · Kidron, OHBuilt 1942 · S/N 75-6539N124BHMccusker Marina · Stuart, FLS/N 75-7606N12557Collins Roger D · Woodinville, WABuilt 1941 · S/N 75-2625N128WRRoe Wade Ryan · Tuscaloosa, ALBuilt 1941 · S/N 75-884N129LOld Goat LLC · Wilmington, DEBuilt 1943 · S/N 75-8581N12EKKnutson Wayne R · Tioga, NDS/N 75-199N12FRWeston David · Burke, VAS/N 75-4581N1307NWeir Ryan L · Buckley, WAS/N 75-5135N1312NNational Museum Of World War II Aviation · Colorado Springs, COBuilt 1944 · S/N 75-5742N1313NBurnham Kenneth J · Carr, COBuilt 1949 · S/N 75-5618N1314NBuermann Henry · Brookfield, VTBuilt 1942 · S/N 75-5617N1315NDevries Douglas F · Everett, WABuilt 1942 · S/N 75-5453N13244Alacoast Vintage Biplanes LLC · Irvington, ALBuilt 1941 · S/N 75-908N1327MMbs Aviation LLC · Topsail Beach, NCBuilt 1943 · S/N 75-8125N1329MStahl John · Union Dale, PABuilt 1943 · S/N 758623N1339MKroenlein Donald G · Moweaqua, ILBuilt 1943 · S/N 75-8637N133RKent Carroll G · Newborn, GABuilt 1942 · S/N 75-6881
Back to AD 46-24-01