OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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

N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454N4564ZJones Brad · Oak Hill, FLBuilt 1961 · S/N 22-8071N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022N4565RHenderson Javier · Raleigh, NCS/N 28-21308N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309N4566WBoling Kyle C · Oak Hill, FLBuilt 1976 · S/N 13056N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079N4566ZPackett Roger L · Yachats, ORBuilt 1961 · S/N 22-8074N4567Amigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11033N45677Davidson Christopher Scott · Friant, CABuilt 1977 · S/N 177RG1126N45678Kdm Aviation LLC · Wilmington, DEBuilt 2012 · S/N 41063N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878N4567TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250136N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879N4568FWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282989N4568QMeacham Barry J · Glasgow, KYBuilt 1985 · S/N 187N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326N4569CReese Brandon A · Bend, ORS/N 25423N4569HPowell Randy N Trustee · Elko, NVBuilt 1979 · S/N 24-0849N4569KJts Aircraft LLC · Rock Hill, SCS/N 5N4569MEllis Wendell Kirk · Gakona, AKBuilt 1947 · S/N 1172N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310N4569VDittmann William H Jr · Palmetto, FLBuilt 1984 · S/N 112N4569XSequoias David O · Waxhaw, NCBuilt 1975 · S/N 287625057N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456N456BABergey Aerospace Co Inc · Norman, OKFirst renewal noticeBuilt 2017 · S/N 0001N456BHCastleton Real Estate & Developlment Inc · El Monte, CAS/N R18201482N456BTHatfield Timothy E · Parowan, UTBuilt 2013 · S/N 4712N456CASlake James T · Portage, INBuilt 1966 · S/N 28-10733N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506N456CSZhang Li · Palo Alto, CABuilt 2016 · S/N 18282451N456CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282445N456DSlesser Carl J · Crestwood, KYBuilt 1993 · S/N 21569N456DJSingle Raj Pa Inc · Seattle, WABuilt 1982 · S/N R18201888N456DPBorder Zachary J · Molalla, ORBuilt 1991 · S/N 365N456DWJstream Lc · Sheridan, WYS/N 21040N456DXAviolease LLC · Vancouver, WABuilt 2005 · S/N 172S9871N456EMMiller William E · Goldsboro, NCBuilt 2013 · S/N 91893N456HLCrawford Clark W Trustee · La Quinta, CABuilt 2013 · S/N 72282N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436N456JDLehner Jeffrey K Trustee · The Woodlands, TXBuilt 2004 · S/N 80485
Back to AD 81-18-04 R2