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.

N2387HOgden Thomas C · New Cumberland, WVBuilt 1946 · S/N 3012N2388HRoozee James B Jr · Crystal Lake, ILBuilt 1946 · S/N 3013N2389H1941 Historical Aircraft Group Museum · Geneseo, NYBuilt 1946 · S/N 3014N2393HSnider Samuel · West Jordan, UTBuilt 1946 · S/N 3018N2394HIngelse David A · Rockford, ILS/N 3019N2395HGrater Timothy F · Knoxville, TNBuilt 1946 · S/N 3020N2396HChowdhury Ajoy · Newark, CABuilt 1946 · S/N 3021N2402HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3027N2407HKirby Brent L · Metamora, MIBuilt 1946 · S/N 3032N2408HPope Bradley L · Woodstock, GABuilt 1946 · S/N 3033N2411HLekas Melissa · Toms River, NJBuilt 1946 · S/N 3036N2415HErcoupe LLC · Colonial Heights, VABuilt 1946 · S/N 3040N2419HPeterson Christopher A · Holt, FLBuilt 1946 · S/N 3044N2425HStevens James L · Morehead, KYBuilt 1946 · S/N 3050N2427HRishovd Thomas A II · Elk River, MNS/N 3052N2428HHowland Gary M · Marysville, KSBuilt 1946 · S/N 3053N2434HBigham Dylan · Windsor, CABuilt 1946 · S/N 3059N2446HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3071N2449HTracy Kevin A · Sequim, WABuilt 1947 · S/N 3074N2467HOmlid Robert L · Watford City, NDBuilt 1946 · S/N 3092N246EZZisman Edward D · Tarpon Springs, FLBuilt 1968 · S/N B-288N2472HDunlap Lloyd A · Brighton, MIBuilt 1946 · S/N 3097N2475HSchroer Jeffery B · Warrenton, MOBuilt 1946 · S/N 3100N2485HMcnutt Richard K · De Pere, WIBuilt 1946 · S/N 3110N2500HNabb Andrew W · Mooresville, NCBuilt 1946 · S/N 3125N2503HCarlson Lyle V · Allen, NEBuilt 1946 · S/N 3128N2511HGalassi Thomas D · Petersburg, ILBuilt 1946 · S/N 3136N2516HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3141N2523HShadd James A · Lancaster, OHBuilt 1946 · S/N 3148N2525HWilliams Randy Hillman · Blue Ridge, GAS/N 3150N2536HGregory Vernon L · Swansea, SCS/N 3161N2537HMaddock Jay B · Sugar Grove, ILS/N 3162N2539HFortune Conversions Corp · Cave Creek, AZBuilt 1946 · S/N 3164N2546HWing Wendall E · Marion, MIBuilt 1946 · S/N 3171N2551HCoupe Groupe Inc · Bayport, NYBuilt 1946 · S/N 3176N2555HJohns Leroy E · Keenesburg, COBuilt 1946 · S/N 3180N2569HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3194N2576HMartin Aaron M · Penn Yan, NYBuilt 1948 · S/N 3201N2586HDix Walter R Jr · Winter Haven, FLBuilt 1946 · S/N 3211N2593HUpham Chester R III · Mineral Wells, TXBuilt 1946 · S/N 3218N2596HLayne Keith R · Oklahoma City, OKBuilt 1946 · S/N 3221N2597HQuantie Harold · Locust Grove, OKBuilt 1946 · S/N 3222N25LKrall James M · Mitchell, SDS/N 5025N2602HWilson Rutledge P III · Marietta, GABuilt 1946 · S/N 3227N2606HOlberding Timothy · Bolingbrook, ILS/N 3231N2608HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3233N2627HGarman Karl E · Crystal Lake, ILBuilt 1946 · S/N 3252N2633HGlenn Michael J · Payson, AZBuilt 1946 · S/N 3258N2634HReaser Jordan Scott · Pacific Palisades, CABuilt 1946 · S/N 3259N2642HBennett Steven A · Boylston, MABuilt 1946 · S/N 3267
Back to AD 94-18-04 R1