OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N318RALouden Bruce H · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 13048N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318SJObr Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282251N318TCGilmer Thomas · Toccoa, GABuilt 1976 · S/N 60-0316-117N318TMOgino Todd T · Barrington, ILBuilt 2009 · S/N 71942N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N318WCDelta Dusters LLC · Lake Providence, LABuilt 2006 · S/N 18281829N318WMQuinn James Yancie · Farmers Branch, TXBuilt 2001 · S/N 1327N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484N3190BThomas Peter G Trustee · Reno, NVBuilt 1953 · S/N 25432N3190MHart David E · Jackson, GABuilt 1947 · S/N 12-2008N31916Registered aircraftS/N 32-7840155N3191MHerder John P · Phoenix, AZBuilt 1947 · S/N 12-2007N3191PStone Clifford F Jr · Corning, CABuilt 1957 · S/N 23-1129N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486N3192CHansen Leland K · Phoenix, AZS/N R18200255N3192THawley James W · Waddell, AZBuilt 1967 · S/N 17700492N31933G & C Flying Inc · Litchfield, ILS/N 32R-7885142N31939Holt Thomas S · Layton, UTBuilt 2018 · S/N 1212N3194PGalindo Don R Jr · Walnut Grove, CABuilt 1980 · S/N 18-8009042N3194WNiehaus Properties Inc · Portland, ORBuilt 2006 · S/N 11173N3195Gorham Luke E · Wichita Falls, TXBuilt 2001 · S/N 4009N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259N3195ZMcgrady Chadwick Paxton · Glade Park, COBuilt 1959 · S/N 18-7191N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488N3196TNicholson Perry R · Merlin, ORBuilt 1968 · S/N 17700496N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260N31977Wedekemper Donald E · Howell, MIBuilt 1978 · S/N 32R-7885148N3197TMundle Jeffrey A · Ashland, ORBuilt 1967 · S/N 17700497N3197ZSlayden Steven M · Rhome, TXBuilt 1959 · S/N 18-7195N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605N3198FDepinet Rodney J · Glen Saint Mary, FLBuilt 1968 · S/N 17256588N31995One Zero Tango LLC · Chattanooga, TNBuilt 1978 · S/N 32R-7885149N31996Seacoast Plane Partners LLC · Exeter, NHBuilt 1978 · S/N 32R-7885151N3199MDe Voe Don F · Anchorage, AKBuilt 1947 · S/N 12-1862N3199TMortgage Experts LLC · Homestead, FLBuilt 1967 · S/N 17700499N319AMJones Arthur L · Bend, ORBuilt 2005 · S/N 2319N319AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496585N319AZRegistered aircraftBuilt 1988 · S/N 1850N319CBBoyer Richard · Georgetown, TXBuilt 2010 · S/N 40441N319CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881505N319DCBecker Dennis P · Kelso, WABuilt 2008 · S/N 23772N319ECRansom Robert W · Moorestown, NJBuilt 1994 · S/N 19032CN319EGVertx Fleet Holdings LLC · San Diego, CABuilt 2021 · S/N 28020021N319ENMedic Choppers LLC · Springdale, ARBuilt 1975 · S/N 319N319EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 172S12277N319FTPerez Guillermo T · Castaic, CABuilt 1982 · S/N 28-8216208
Back to AD 81-18-04 R2