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.

N50AZBenson Aviation LLC · Mehoopany, PAS/N 2093N50BGStilson Scott · Ivins, UTBuilt 1976 · S/N 14184N50BTWade William T · Fairhope, ALBuilt 1974 · S/N 28-7415164N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227N50CAllred & Associates Inc · Skaneateles, NYBuilt 1965 · S/N 891N50CABachmann Erik J · High Bridge, NJS/N CA001N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76N50CPAtkins Daniel E · Marlette, MIBuilt 1978 · S/N R18200246N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50CXChristmas Candy · Angel Fire, NMBuilt 1979 · S/N R18201040N50DCConrad David J · Wausau, WIBuilt 1993 · S/N 282N50DFCargille Joshua C · Kenosha, WIBuilt 1981 · S/N 122550N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50DPRenkel Christopher P · Westlake, OHS/N BROUSSARD 0001N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50EHSands Thomas · Columbia Falls, MTBuilt 2000 · S/N 2083N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50GFHarrington Brian · Fountain Inn, SCBuilt 1950 · S/N 20-382N50GWWomack Craig D · Carlsbad, CABuilt 1993 · S/N 20370N50HCFroggy Too LLC · Sheridan, WYBuilt 2025 · S/N 3456N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135N50HURovegno Paul C II · Burlington, NCBuilt 1996 · S/N 1320N50HYGrossman David G · Itta Bena, MSBuilt 2000 · S/N 2116N50JAAday B Joe · Las Cruces, NMBuilt 1979 · S/N 18-8009002N50JKPorter Judson · El Paso, TXBuilt 2001 · S/N 25405N50JPPowell John R · Baton Rouge, LABuilt 2013 · S/N 24118N50JSSegura Speed Shop LLC · Henderson, TXBuilt 1992 · S/N S-032447-1N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50KFBlade Capital Inc · Fort Lauderdale, FLBuilt 2009 · S/N 2035N50KMSexton David · Forney, TXBuilt 1991 · S/N 283N50KRVortex Air LLC · Philpot, KYBuilt 2014 · S/N 2379N50KSShuman Kenneth R · Adrian, MIBuilt 2001 · S/N 20535N50KWDsw Aircraft Ltd LLC · Kalispell, MTBuilt 2023 · S/N 42579N50LEFoulk Justin W · Yeagertown, PABuilt 1999 · S/N LE001N50LHRegistration Pending · Pensacola, FLRegistration pendingBuilt 2004 · S/N 81170N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95N50MDBeifia Bedia Rafael · Winchester, VABuilt 1984 · S/N PA604N50MHWolpin Stephen A · Santa Paula, CABuilt 1984 · S/N 1403N50MRWhite Gordon · Bulverde, TXBuilt 1993 · S/N 21720N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50PVVose Robert · Rye, NHBuilt 2009 · S/N PV192N50PWHandi Corner Inc · Sandersville, GABuilt 1978 · S/N 32R-7885045N50RBBenson Ross A · Granbury, TXBuilt 1987 · S/N 757N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50RFFecteau Robert · Taylorsville, NCBuilt 2020 · S/N 18283099
Back to AD 81-18-04 R2