OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N12MFitzpatrick H Mike · Cleveland, GABuilt 2010 · S/N 60548N12MBHarrison Hayden F · Mckean, PAS/N 1948N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12MVKarduck Craig · Morgan, UTS/N 3671N12NCPeck Nathan M · Leavenworth, KSBuilt 1994 · S/N 1741-LN12NMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 0036AKN12PShalun Lukas A · Germantown, TNBuilt 1977 · S/N 001N12PKDuncan Aviation Inc · Lincoln, NEBuilt 2000 · S/N 2103N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98N12PSMurphy Peter · Johns Creek, GABuilt 1981 · S/N 44-8107047N12PUMeyer Daniel B · Redding, CABuilt 1998 · S/N 008N12PXMvs Air LLC · Kalispell, MTS/N 61P-0524-220N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N12QRWilson Koby D · Southside, ARBuilt 2000 · S/N 2121N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N12REWilliams Jeffrey · Georgetown, INBuilt 1982 · S/N EPPLETT-0001N12RZZapsky Richard M Jr · Houtzdale, PABuilt 2000 · S/N 5585N12SDStevens Sam D · Isola, MSBuilt 1973 · S/N 1376N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N12SVHarmacinski Larry Trustee · Punta Gorda, FLBuilt 1947 · S/N 418N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12TRRegistered aircraftBuilt 1991 · S/N 10053N12TSSmith Thomas R C · Suisun City, CABuilt 2001 · S/N 1353N12VEMorrison Benjamin Franklin III · Godley, TXBuilt 1983 · S/N 32365279N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187N12VRCulver Lane M · Laceys Spring, ALBuilt 1988 · S/N 10058CN12VSCal-Aerofab Flight Academy · Chino, CABuilt 2008 · S/N 71542N12WAIoe Aviation LLC · Kirkland, WABuilt 1994 · S/N 21712N12WKGallagher Glenn C · Lakeland, FLBuilt 1984 · S/N 5811N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013N12XGCommander Aviation LLC · Williamsburg, VABuilt 1977 · S/N 14237N12XZ140 LLC · Birmingham, ALS/N 13182N12YKinslow Eugene C Jr · Prospect, KYBuilt 1965 · S/N 562N12YCCedarview Airport Investments LLC · Orlando, FLBuilt 2022 · S/N 3395N12YRHauck Scott · Loveland, OHBuilt 2012 · S/N 5829N12ZVon Gottsegen Erik · Sweet Home, ORBuilt 1976 · S/N 16N12ZFJohnson Ross · Anderson, SCBuilt 2000 · S/N 9912CCN12ZX24-3227 Inc Trustee · Wilmington, DEBuilt 1991 · S/N 24-3227N13004Regnier Ryan A · Lockport, ILBuilt 1973 · S/N 17262439N13008Midnite Sun Flying Club LLC · Eagle River, AKBuilt 1974 · S/N 17262441N13009Laffey Joseph C · Saint Louis, MOBuilt 1973 · S/N 17262442N1300AMann Lee S · Euless, TXBuilt 1966 · S/N 1064N1300CSelf James M · Fennville, MIBuilt 1953 · S/N 22-1102N1300PHerzog Gregory L · Star, IDBuilt 2001 · S/N 18068C
Back to AD 81-18-04 R2