OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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

N2120HGregory Vernon L · Swansea, SCS/N 2787N2122HSmith Gaynor J · Clay Center, NEBuilt 1946 · S/N 2745N2128HVecchio Alfred James · Emerado, NDBuilt 1946 · S/N 2751N2129HMathison John M · Fernley, NVBuilt 1946 · S/N 2752N2134HSullivan James E · Bismarck, NDBuilt 1946 · S/N 2757N2149HGovin James M · Ball Ground, GABuilt 1946 · S/N 2772N214RPSale Reported · Osage, IASale reportedBuilt 1947 · S/N 4793N2166HCrone Janice C · Frederick, MDBuilt 1946 · S/N 2789N2169HPecoraro Carmine F · Kirkland, WABuilt 1946 · S/N 2792N2176HLandry Robert J · Winston Salem, NCBuilt 1946 · S/N 2799N2180HGraf Edwin X · Washington Island, WIBuilt 1946 · S/N 2803N2191HCoulson Mark Douglas · Zanesville, OHBuilt 1946 · S/N 2814N21DBStaton Riley J · Hayden, IDS/N A-232N2203HKhanna Varun · Kent, WABuilt 1946 · S/N 2826N2212HDenault Christopher A · Union Hill, ILBuilt 1946 · S/N 2835N2213HValentine Rolland N · Atlanta, MIBuilt 1946 · S/N 2836N2231HHorn Patricia A · Hartland, WIS/N 2854N2237HEason James D · Leawood, KSBuilt 1946 · S/N 2860N2239HGreen Michael B · Kent, WABuilt 1946 · S/N 2862N2240HRoberts Shane · Las Cruces, NMBuilt 1946 · S/N 2863N2247HGerdes Brian K · Los Alamitos, CABuilt 1946 · S/N 2870N2248HPayne Emily R · Lake Mills, IABuilt 1946 · S/N 2871N2250HZahner Paul G · Fairfield, CABuilt 1946 · S/N 2873N2253HBlakely Charles G · Ellijay, GABuilt 1946 · S/N 2878N2256HKoberstein Tracy T · Pilot Rock, ORS/N 2881N22617Then Michael J · Troy, OHBuilt 1970 · S/N 700030N2270HGehrman Holdings LLC · De Pere, WIBuilt 1946 · S/N 2895N2273HWright Colleen E · Punta Gorda, FLBuilt 1946 · S/N 2898N2278HEcho Matrix LLC · Bentonville, ARBuilt 1946 · S/N 2903N2279HCook Michael E · Collinsville, ILBuilt 1946 · S/N 2904N2282HPerkins Gary N · Maineville, OHBuilt 1946 · S/N 2907N2302HEnigma Aircraft LLC · Benton Harbor, MIBuilt 1946 · S/N 2927N2306HDugas Thomas · Vancouver, WABuilt 1946 · S/N 2931N2318H355 Flyers Association · Moses Lake, WABuilt 1946 · S/N 2943N2326HMalmaison Road LLC · Lewes, DEBuilt 1946 · S/N 2951N2327HDelaware Aviation Museum Foundation · Georgetown, DEBuilt 1946 · S/N 2952N23343Gassert Kevin · Cincinnati, OHS/N 2959N2335HRosenquist Susan L · Chisago City, MNBuilt 1946 · S/N 2960N2338HSmith William Alan Charles · Davenport, IABuilt 1946 · S/N 2963N2347HKerr Phillip D · Beebe, ARS/N 2972N2354HGriffin Lea Edward · Beaufort, NCBuilt 1946 · S/N 2979N2356HRegester Robert H · Indianapolis, INBuilt 1946 · S/N 2981N2357HFarris Mark E · Richmond, KYBuilt 1946 · S/N 2982N2360HWilson Gary L · Moultrie, GAS/N 2985N2365HCassels William · Phoenix, AZBuilt 1946 · S/N 2990N2367HGoodman Harlon · Ontario, NYBuilt 1946 · S/N 2992N236FBPietrosemoli Castagni Andres · Cary, NCBuilt 1966 · S/N A-158N2374HCurtner Mark A · Sidney, OHS/N 2999N2383HSale Reported · Decatur, TXSale reportedBuilt 1946 · S/N 3008N2385HNeer Brent A · Nampa, IDS/N 3010
Back to AD 94-18-04 R1