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.

N5473F8s1-51 LLC · Polson, MTBuilt 1968 · S/N B-273N5474FRaymond Patrick H · Jerseyville, ILBuilt 1968 · S/N B-274N5475FWinger Christopher W · Maplewood, MNBuilt 1968 · S/N B-275N5476ENorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N A-10N5476FHeacock Anthony A · Chino Hills, CABuilt 1968 · S/N B-276N5477EVolatilis LLC · Wilmington, DEBuilt 1965 · S/N A-11N5478FTompkins Robert George · Frankfurt Am MainBuilt 1968 · S/N B-278N5479ESurmick Chad C · Santa Rosa, CABuilt 1965 · S/N A-13N5482FDahlberg David F · Basking Ridge, NJBuilt 1968 · S/N B-282N5483FGray Melvin D Trustee · Appleton, WIBuilt 1968 · S/N B-283N5484EHarmon Daniel · Josephine, TXBuilt 1965 · S/N A-18N5485FGarretson Frederick M · Gardners, PABuilt 1968 · S/N B-285N5486FSchmitt Kenneth R · Springfield, ORBuilt 1968 · S/N B-286N5488ELancaster Kenneth B · Bremen, ALBuilt 1965 · S/N A22N5489FBraden John H · Watseka, ILBuilt 1968 · S/N B-289N5493FBowen John W · Kenai, AKBuilt 1968 · S/N B-293N5494FMullen Andrew P · North Miami Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N B-294N5495FMeyer Daniel L · Norfolk, NEBuilt 1968 · S/N B-295N5497FJacques Denis A · Weirsdale, FLBuilt 1969 · S/N B-297N5582LHyr Inc · Hayward, WIS/N A-130N55HELyon John D · Los Angeles, CABuilt 1965 · S/N A-23N5600FBiehl Edgar A · Grove City, OHBuilt 1966 · S/N A-200N5603FWoerle Edward R · Rossville, TNBuilt 1966 · S/N A-203N5604FMcnamara Patrick E · Adams, TNBuilt 1966 · S/N A-204N5606FCavu Aviation LLC · Cedar Park, TXBuilt 1966 · S/N A-206N5609FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-209N5612FWilliams Eddie R · Golden Valley, AZS/N A-212N5614FKatzakian Trevor T · Lodi, CAS/N A-214N5615FBalderston Daniel · Garden Grove, CABuilt 1966 · S/N A-215N5616FHoak Edward C · Duncannon, PABuilt 1966 · S/N A-216N5617FNiemi Fred H · Lake City, MIBuilt 1966 · S/N A-217N5618FClanton Thomas I · Maryville, TNBuilt 1966 · S/N A-218N5620FLight Sport LLC · Payson, AZBuilt 1966 · S/N A-220N5621FBullock Robert · Mount Airy, MDBuilt 1966 · S/N A-221N5624FGunsch Matthew T · Phoenix, AZBuilt 1966 · S/N A-224N5625FWilson Bobby R · Kathleen, GABuilt 1966 · S/N A-225N5629FShawn James Robert · Pattison, TXS/N A-229N5631FHolladay Leonard R · Greeley, COS/N A-231N5635FMartinez Jose A · Pensacola, FLS/N A-235N5637FLong William M · Hemphill, TXBuilt 1967 · S/N A-237N5638FFisk Christopher J · Hammonton, NJBuilt 1967 · S/N A-238N5640FMcneill William F · Raeford, NCBuilt 1967 · S/N A-240N5641FBogue Bruce E · Washington, MOBuilt 1967 · S/N A-241N5642FTiger Flight Foundation Inc · Rome, GABuilt 1967 · S/N A-242N5643FWoodhaven Air LLC · Blue Springs, MOBuilt 1967 · S/N A-243N5650FMcdonald Ryan · Sugarland, TXBuilt 1967 · S/N B-250N5652FHayden Robert P · West Fargo, NDBuilt 1966 · S/N A-152N5653FCrowe James E · Sylvester, GABuilt 1966 · S/N A-153N5659FMonske Nicholas J · Austin, TXBuilt 1966 · S/N A-159N5663FHenley Enterprise Inc · West Palm Beach, FLS/N A-163
Back to AD 94-18-04 R1