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.

N5090RStahla Russell A · Girdwood, AKBuilt 1976 · S/N 18503005N5090UVolatile Aero Ventures LLC · Boulder City, NVS/N 206-0090N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5091VWilliams Timothy J · Fernandina Beach, FLBuilt 1975 · S/N 21060833N5092NMill-Run LLC · Lewes, DES/N D-9893N50937Tls Aviation LLC · Eldridge, IABuilt 1973 · S/N U20601953N50939Heart X Aviation LLC · Salmon, IDBuilt 1973 · S/N U20601954N50958Stangel Richard C · Enterprise, ORBuilt 1973 · S/N U20601961N5096RProvestment International LLC · West Melbourne, FLBuilt 2001 · S/N TH-1996N5097JFencer Michael J · Wilmington, MAS/N 310R0217N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024N509CDTfs Limited LLC · Scarborough, MEBuilt 2004 · S/N 1194N509CETitle Associates LLC · Hurricane, UTBuilt 2004 · S/N 0979N509JMRegistered aircraftBuilt 1980 · S/N D10352N509MCCicerchi Michael P · Denver, COBuilt 2015 · S/N 57N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947N509RRAlten Flight LLC · Northbrook, ILBuilt 2004 · S/N 0843N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N50AUDapp Eric M · Corvallis, ORS/N 1851368N50AWLillian Aviation LLC · Cypress, TXBuilt 1977 · S/N 18503528N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50CTAyers Jeffrey D · Canandaigua, NYBuilt 1978 · S/N 21062937N50DDQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000331N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526N50ECPremier Wireless LLC · Kalispell, MTBuilt 1998 · S/N 29-0169N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217N50HWMills Charles K · Hernando, FLBuilt 1978 · S/N U20604558N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141N50LPParker-Long LLC · Lexington, NCBuilt 2026 · S/N TH-2551N50LWFlyer One LLC · Palm Harbor, FLBuilt 1970 · S/N TE-790N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N50MBCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1980 · S/N U20605577N50RHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000738N50SHVitatoe Industries Inc · Chillicothe, OHBuilt 1978 · S/N P21000178N50TFLittlefield Keith A · Kent, WABuilt 1979 · S/N 18503952N50ZTackes Steven · Carson City, NVBuilt 1969 · S/N D-8929N5105JNickravesh Niknam John · Saratoga, CABuilt 1975 · S/N 310R0225N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705N5107WRugger Investment Group LLC · Sheridan, WYBuilt 1981 · S/N P21000640N5108QPardue William C Jr · Leesville, LABuilt 1975 · S/N U20603060N5108TMarks Daniel A · Portersville, PABuilt 1977 · S/N 18503274N5109QRmcb LLC · Kalispell, MTBuilt 1972 · S/N 21059609N510AASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064699N510CDMcgraw Jon W · Sitka, AKBuilt 2005 · S/N 1324N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001
Back to AD 86-13-04 R3