OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N6869LWeatherby Joseph III Trustee · Cuyahoga Falls, OHBuilt 2000 · S/N 29-0229N686AGBon Air LLC · Chickasha, OKBuilt 2016 · S/N E-4085N686FRVon Syke Orchards LLC · Anderson, SCBuilt 1979 · S/N TH-1015N686MGMike Golf Holdings LLC · Pinellas Park, FLBuilt 1981 · S/N 18504314N68707Ascp Blue Skies LLC · Columbia, MOS/N 340A1515N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998N68717Horst Paul A · Clarkrange, TNBuilt 1982 · S/N 340A1526N6871DPickett Aviation LLC · Brownsboro, ALBuilt 1982 · S/N 340A1519N68752Hyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0518N6875DHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0511N6878LMurawski Todd · Port Austin, MIBuilt 1988 · S/N CE1279N6879RHyannis Air Service Inc · Hyannis, MAS/N 402C0611N687HVAmerican Airpower Heritage Flying Museum · Dallas, TXS/N BG21N687SAGerstein Lee · Park City, UTBuilt 2001 · S/N EA-687N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289N688MLeading Edge Aviation Inc · Bend, ORBuilt 1972 · S/N CE-391N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603N6895HNyholm Kurt S · Duluth, MNS/N 18503342N6899BCowgill Robert W · Amissville, VABuilt 1978 · S/N 21062852N689CAir Mt A36 LLC · Lake Havasu City, AZBuilt 2002 · S/N E-3461N689TNunez Manuel · Mcallen, TXS/N D-7408N68APAbecca Corporation · Jackson, MIBuilt 1968 · S/N D-8899N68BMDavenport Donald · North Las Vegas, NVBuilt 1977 · S/N 21062441N68BQUnfinished Journey LLC · Dover, DEBuilt 1978 · S/N TH-952N68CTSilver Arrow LLC · Alvin, TXBuilt 1980 · S/N TE-1174N68DXFreeman David J · Seattle, WABuilt 2002 · S/N 0214N68EAPav East LLC · Camden, DEBuilt 1985 · S/N P21000837N68FJBurns James A · Madison, WIBuilt 1973 · S/N 73-30578N68JFAjs Aviation LLC · Warroad, MNS/N U20606728N68JPDocs Aviation LLC · Saint Peters, MOS/N TE-854N68JWBobcat Aviation LLC · South Hutchinson, KSBuilt 1978 · S/N 340A0500N68KLVoloshin Vitaly · Seattle, WABuilt 1977 · S/N 340A0258N68MGDreger Dean R · Wilbur, WABuilt 1981 · S/N 21064392N68MMLetters Inc · Santa Maria, CABuilt 1979 · S/N EA-5N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399N68RDWilliams Gerald L · Malibu, CABuilt 1965 · S/N 320D0026N68RTWrye David · Kevil, KYBuilt 1991 · S/N CE1629N68SMSimms Richard J · Shady Shores, TXBuilt 1968 · S/N D-8779N68SYFreeman William M · Cameron Park, CABuilt 2004 · S/N 0930N68TBSmith Ronald A · Los Gatos, CABuilt 1981 · S/N 21064492N68TRNaim Danial Shelby · Iowa Park, TXBuilt 1975 · S/N 75-30749N68WAChuss Edward J · Metamora, MIBuilt 1968 · S/N 421-0137N6900XMueller Robert C · Reno, NVBuilt 1977 · S/N 21062392N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301N6908MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700672N6908PSix Six Hotel Corporation · Bangor, PABuilt 1985 · S/N 46-8508062N6908XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508064N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309N690FSYork Randal G · Cullman, ALBuilt 1969 · S/N TE-710N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310
Back to AD 86-13-04 R3