OpenAirDocs.org
AD 74-18-13

Registered aircraft · 1,642

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-18-13')
    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-18-13')
  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.

N2750MMcgibbon Aviation LLC · Denver, COS/N 32-7840053N275TMShank Lee M · Iron Station, NCBuilt 1979 · S/N 32-7940275N276TMVolante LLC · Livermore, CABuilt 1978 · S/N 327940006N2772PFix Repair LLC · Helena, MTBuilt 1968 · S/N 32-40456N2777NSpencer John · Indian, AKS/N 32-7240003N2785QA&R Aero LLC · Sacramento, CABuilt 1966 · S/N 32-688N279JHBravo Zulu Aviators LLC · Midland, TXBuilt 1978 · S/N 32-7840138N27DASiewruk Cameron M · Stuart, FLBuilt 1978 · S/N 32-7840084N2821GH&M Air LLC · Metamora, MIBuilt 1979 · S/N 32-7940137N2826HN2826h LLC · Elizabethville, PABuilt 1979 · S/N 32-7940144N2826XAero Talons LLC · Nashville, TNS/N 32-7940145N2826YMorgan Lewis Brian · Allen, TXS/N 32-7940146N2843GPopop Corp · Portland, ORBuilt 1979 · S/N 32-7940152N2843MCar Store Inc · Honolulu, HIBuilt 1979 · S/N 32-7940154N2850YMarjanro Aviation LLC · Marco Island, FLBuilt 1979 · S/N 32-7940157N2857MCoastal Air Services LLC · Hampton, SCBuilt 1977 · S/N 32-7840057N2858HSundt Daniel N Jr Trustee · Bryn Mawr, PABuilt 1979 · S/N 32-7940162N28693Velocity Air LLC · Lebanon, TNBuilt 1979 · S/N 32-7940121N28708Camacho David P · Macon, NCS/N 32-7940122N2870TDohrenwend Michael P · Huntsville, ALBuilt 1972 · S/N 32-7200028N2872DLeggio David R · Boyce, LABuilt 1979 · S/N 32-7940167N2873UBaker Douglas R · Ann Arbor, MIS/N 32-7940171N2873XJag III Aviation LLC · Clarksdale, MSS/N 32-7940172N2881GGardocki Joseph E · Oklahoma City, OKBuilt 1979 · S/N 32-7940177N2881ZHoag Peter J · Arlington Heights, ILBuilt 1979 · S/N 32-7940181N2884MWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7840058N2891GIsland Air Taxi LLC · Put In Bay, OHS/N 32-7940183N2891YCherry Hill Aviation Inc · Freetown, INS/N 32-7940185N28933Lewis Group Properties LLC · Apex, NCBuilt 1979 · S/N 32-7940123N28935Kremer Brian F · Iona, MNBuilt 1979 · S/N 32-7940124N2897XCoastal Air LLC · Naknek, AKS/N 32-7940187N2899DPye Houston W · Cloudcroft, NMBuilt 1979 · S/N 32-7940192N2899NTailwinds Flying Club · Lake Elmo, MNS/N 32-7940193N289HRJcm Development Co LLC · Manchester, NHBuilt 1975 · S/N 32-7640044N28BEHaas Edward F · Batesville, ARBuilt 1979 · S/N 32-7940147N28HSStone Michael S · Chamois, MOBuilt 1967 · S/N 32-40351N2905BHawley Timothy J · Ashland, OHBuilt 1979 · S/N 32-7940194N2909BIsland Hoppers Inc · Glenridge, NJBuilt 1979 · S/N 32-7940196N29145Rapid Permits LLC · Duck Key, FLS/N 32-7940128N29157Midwest Aero Inc · Bay City, MIBuilt 1979 · S/N 32-7940130N29170Kuhlmann Connor · Ada, MIBuilt 1979 · S/N 32-7940131N29172Reutter David C · Mount Kisco, NYBuilt 1979 · S/N 32-7940132N2921NZephyr Air Corp · Dellwood, MNBuilt 1979 · S/N 32-7940204N2921SAirworthy Services LLC · Pompano Beach, FLBuilt 1979 · S/N 32-7940203N2923NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 32-7940207N2927CMcvey Wesley · Frisco, TXBuilt 1979 · S/N 32-7940211N2928AVista Aircraft Lc · Papillion, NES/N 32-7940212N2928XBurger Andrew J · Cincinnati, OHBuilt 1979 · S/N 32-7940216N292AWPalmetto Air LLC · Spartanburg, SCS/N 32-7840061N2932FIceman Holdings LLC · Greer, SCBuilt 1979 · S/N 32-7940218
Back to AD 74-18-13