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.

N1418TZucchi Steven · Ephrata, PABuilt 1972 · S/N 28-7205295N1418VBeverly Flight Center LLC · Middleton, MABuilt 1974 · S/N 17263563N1418XHaskin Kent B · Claverack, NYBuilt 1975 · S/N 28R-7535276N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724N1419DAir America Flight Center LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10671N1419FAir Callahan LLC · Bonita Springs, FLBuilt 2008 · S/N 172S10672N1419TBrolan Aviation LLC · Kansas City, MOS/N 28R-7235283N141AAHeavy Metal Air LLC · Farmingdale, NYBuilt 2007 · S/N 172S10630N141ACGann Steve W · Southaven, MSS/N AA5-0743N141AFSmith Michael J · Brandon, MSBuilt 1995 · S/N 0014N141ANWells Ryan · Holdrege, NES/N 32-7940062N141AREpp Robert Jackson · New Kent, VAS/N 8060CN141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022N141CCDavis Steven M · Eastsound, WABuilt 1991 · S/N 01N141CDSky Helicopters Inc · Desoto, TXBuilt 2023 · S/N 30091N141CGJackson Glenn E · Byron, MNS/N 683RN141CHRegistered aircraftBuilt 1979 · S/N 324-79N141CJKramer Benjamin P Trustee · Carson City, NVBuilt 1985 · S/N F8L-518N141CLFulbright Charles M · Toccoa, GABuilt 1967 · S/N TD-692N141CMMoran Christopher C · Colleyville, TXBuilt 2022 · S/N 42310N141DDCox Aviation Services LLC · Acworth, GABuilt 1999 · S/N 3246132N141DFNaumann Reuben D · Blackwell, MOS/N 19011CN141EGage Christopher P · Coeur D Alene, IDBuilt 2020 · S/N 001N141ERStein Richard M · Sierra Vista, AZS/N 1335N141FAnderson Jon J · Hill City, SDBuilt 1998 · S/N 1400N141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2019 · S/N 2881158N141FQCross Daniel · Windham, NHS/N 28-8290176N141FWSchultz Frank R · Lafayette, COBuilt 2011 · S/N 22898N141JStocks Judy K Trustee · Lubbock, TXBuilt 1999 · S/N 23376N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79N141KRScanlon John (Jack) · Palos Heights, ILBuilt 1972 · S/N 28-7225206N141NCheney John A · North Baltimore, OHBuilt 1976 · S/N 902N141PNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-237N141PFFordham Aviation Inc · Eastman, GABuilt 1978 · S/N 17271503N141RBClevenger Glen D · Cottage Grove, ORFirst renewal noticeBuilt 1997 · S/N 22285N141RSFrederick Investment Corp · Raleigh, NCS/N 26006CN141SCVance John C · Coleman, TXBuilt 2000 · S/N 1286-99N141SEHydro Flyers LLC · Woodside, CABuilt 2006 · S/N 1024-2006N141STBeeghly James H L · Coralville, IABuilt 2008 · S/N ST-001-08N141SWCouture Logan · Grand Forks, NDBuilt 1975 · S/N 28-7625006N141TRipley Jesse W · Wasilla, AKBuilt 1953 · S/N 18-2255N141TAPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715201N141TJHolderman James M · Santa Cruz, CABuilt 2002 · S/N 5190N141TRHamidi Saeid · Yorba Linda, CABuilt 2018 · S/N 1001N141USDunkerley Mark · Washington, DCS/N 3059N141WAJohnston James E · Fernandina Beach, FLBuilt 1980 · S/N 28-8116135N1420N5504r LLC · Jefferson City, MOBuilt 1993 · S/N 10172N14205Dfi Aviation Services LLC · Herndon, VABuilt 2007 · S/N 18281889
Back to AD 81-18-04 R2