OpenAirDocs.org
AD 74-23-09

Registered aircraft · 322

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

N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417N10NRRobbins Warren N · Chandler, AZBuilt 1968 · S/N M-1165N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N117DMApplied Professional Solutions Llp · Jacksonville, FLBuilt 1968 · S/N MB-381N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456N17BWLoeffler Helmut Guenter · Prattsburgh, NYBuilt 1968 · S/N MB-344N18BWFarris Fred · Gladstone, MOBuilt 1969 · S/N MB-431N1963FSarna David E · Manawa, WIBuilt 1963 · S/N M-541N2127UFox Robert H · Wyandotte, MIBuilt 1969 · S/N MB-447N222BBMatz Jeremy L · Toston, MTS/N M-250N2300JRadosevich Michael K · Albuquerque, NMBuilt 1963 · S/N M-246N2300LAv8n Idaho LLC · Greenleaf, IDBuilt 1962 · S/N M-112N2301LMuskrat Flying Club LLC · Orlando, FLBuilt 1963 · S/N M-122N2301ZRegistration Pending · Maumee, OHRegistration pendingBuilt 1962 · S/N M-4N2302ZJohnson Melvin L · Toney, ALBuilt 1962 · S/N M-5N2303QVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N M-369N2303ZBeech Aero Club · Ashburn, VABuilt 1962 · S/N M-6N2304LJohnson Diversified LLC · East Lansing, MIBuilt 1963 · S/N M-125N2304QAviation Business Corp · Saint Louis, MOBuilt 1963 · S/N M-356N2306QVanderwielen Joseph M · Neenah, WIBuilt 1963 · S/N M-358N2307LZamel Andre · Sunrise, FLBuilt 1962 · S/N M-128N2307QWinters Jeffrey · Olathe, KSBuilt 1963 · S/N M-367N2308JMcgary Blaine J · Pasco, WABuilt 1963 · S/N M-259N2309QBorja Nicholas F · Freeburg, ILBuilt 1963 · S/N M-373N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138N2312QMiller Kevin · Dover, DES/N M-376N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35N2314JAce Aviation Seminars LLC · Armuchee, GABuilt 1963 · S/N M-377N2314LSale Reported · Brunswick, OHSale reported, canceledBuilt 1963 · S/N M-140N2316LCarrigan Sean P · Slidell, LABuilt 1963 · S/N M-142N2317LAdamiak Jeffrey · Mount Laurel, NJBuilt 1963 · S/N M-143N2318ZCrosson Ronda L · Corinth, MEBuilt 1962 · S/N M-45N2319WWinstead Walley K · Leavenworth, KSBuilt 1965 · S/N MB-1N2320WThompson Robert J · Irwin, PABuilt 1966 · S/N MB-2N2321LHill Tim C · Savannah, GABuilt 1963 · S/N M-147N2321QHarkness James D · Locust Grove, VABuilt 1963 · S/N M-385N2324L2324l LLC · Sharpsburg, GABuilt 1963 · S/N M-150N2325QPoitras Don T · Cary, NCBuilt 1963 · S/N M-389N2328ZEagle Richard R · Catawba, NCBuilt 1962 · S/N M-31N2329LJessup Gordon J R · White Plains, NYBuilt 1963 · S/N M-160N2329WSwonke Adam J · Spring, TXBuilt 1966 · S/N MB-20N2331JTechnical Education Services Inc · Virginia Beach, VABuilt 1963 · S/N M-284N2331ZDovetail Aviation LLC · Saint George, UTBuilt 1962 · S/N M-41N2333QLawarch LLC · Hollywood, FLBuilt 1963 · S/N M-399N2334LDupuy Christopher R · Pass Christian, MSBuilt 1963 · S/N M-165N2334QBledsoe Timothy Ronald Jr · Woodstock, GABuilt 1963 · S/N M-396
Back to AD 74-23-09