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.

N96DTPierson Richard R · Galesville, WIBuilt 1978 · S/N 28-7990230N96EBBills Curt R · Dimmitt, TXBuilt 2008 · S/N 82695N96EJDorris Terry · Greenbrier, TNS/N 001N96ELJimenez-Cruz Juan C · Mayaguez, PRBuilt 1966 · S/N 28-3615N96EZBurk Ross · Casper, WYS/N 1321N96FASilver Express Co · Miami, FLBuilt 2005 · S/N 172S10002N96FDPb Marchetti LLC · West Palm Beach, FLBuilt 1990 · S/N 783N96FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13205N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184N96FSSmidler Francis S · Zionsville, INFirst renewal noticeBuilt 2008 · S/N 21585N96GFHile Phillip J · Harrison, OHBuilt 1996 · S/N 633-320-378N96GMRice Wayne R · Grand Coulee, WABuilt 2009 · S/N 2443N96GWStranberg Jonathan E · White Heath, ILBuilt 1996 · S/N 910N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30N96HGHawdon Neil J · Federal Way, WABuilt 2002 · S/N 357RN96HHRitzenthaler Hugo A · Rochester Hills, MIBuilt 1984 · S/N 8-0100N96HSKundert Matthew J · Rochester, MNBuilt 1989 · S/N 1190N96HUBristol Bay Fisheries Inc · Angwin, CABuilt 1996 · S/N 1307N96JNPetz Leroy E Jr · Montverde, FLBuilt 1985 · S/N 39-91N96JPMclean William E · Daleville, ALBuilt 2002 · S/N 1437N96KMijangos Adrian E · Mary Esther, FLBuilt 1977 · S/N 28-7725269N96KCJws Aviation LLC · Easton, CTBuilt 1997 · S/N 3246087N96KEAbb Aviation LLC · Hammond, LABuilt 2015 · S/N 40231N96KMLinder Richard L · Tulsa, OKBuilt 1996 · S/N 081N96KSMower Douglas D · Cedar Ridge, CAS/N 24-3361N96LEStroud Michael L · Kemmerer, WYBuilt 2000 · S/N 60083N96LJHiller Alex T · Lake Orion, MIBuilt 1997 · S/N 737N96LZRegistered aircraftBuilt 2025 · S/N 590N96MERegistration Pending · Redmond, ORRegistration pendingBuilt 1996 · S/N 14071CN96MKKukulski Michael · Grayslake, ILBuilt 1998 · S/N 1811N96MLM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7940009N96NHMeade John P · Wentworth, NHBuilt 2025 · S/N 69P-149P/150P-P446N96PABloemker Edward L · Fremont, NEBuilt 2010 · S/N 3090N96PCMurphy Walter · Sparks, NVBuilt 1999 · S/N GS-5482N96PJCarter Bruce J · Longboat Key, FLBuilt 1996 · S/N 0203N96RCSouthern Wings Aircraft Sales Ltd · Bethany, OKBuilt 1980 · S/N MC-652N96RDZonczyk Micheal · Keene, NHBuilt 1995 · S/N 214N96RGKim Sung S · Upland, CABuilt 1975 · S/N RBGIIN96RJTweed Robert B Trustee · Fitchburg, WIBuilt 2001 · S/N 96N96RKKomro Robert J · Durand, WIBuilt 1996 · S/N 1316N96RLLewair Flight Solutions LLC · Brighton, COBuilt 2000 · S/N 22923N96RMMitchell Ronald L · East Leroy, MIBuilt 1995 · S/N 001N96RSTarpley Tim · Dallas, ORBuilt 1999 · S/N 24749N96RTTurnock Russell John · Jesup, GAS/N 956N96SCLarson Richard A · Lawndale, CABuilt 1989 · S/N 1809032N96SEHeinlein Stephen · Johns Island, SCBuilt 2000 · S/N 001N96SLSchulz Matthew E · Belmont, CABuilt 1996 · S/N 22013CN96TBBeattie Thomas B · Vacaville, CABuilt 1976 · S/N 28-7690144N96TDCherry William S · Wilmington, NCBuilt 2010 · S/N 81631N96TGCampana Aviation LLC · George West, TXBuilt 2000 · S/N 18280802
Back to AD 81-18-04 R2