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.

N444SRr&D Lp · Fayetteville, NCBuilt 1985 · S/N TJ-490N444SBN1849p LLC · Wilmington, DEBuilt 2008 · S/N E3844N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444UJAmbush Aviation LLC · Anabel, MOBuilt 2005 · S/N 1348N444VPBalzer Joseph W · Sevierville, TNBuilt 1962 · S/N NAV-4-2432N444WELiberty Steaks LLC · Latham, NYBuilt 2004 · S/N E-3579N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N4451SCaporale Ron · Dillon, MTBuilt 1975 · S/N E-683N4451WFlying On Edge LLC · Redmond, WABuilt 1974 · S/N CE-491N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4453QKeene Greggory L · Abbeville, GABuilt 1971 · S/N 18800853N4455Sanders Russell · Canton, GAS/N 41048N4455QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800855N4456SFressh Air LLC · Vancouver, WABuilt 1975 · S/N E-688N4456WMetal Finishing Co Inc · Wichita, KSBuilt 1974 · S/N E-537N4457SRegistered aircraftBuilt 1975 · S/N D-9775N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691N4463SJ&J Aviation LLC · Hendersonville, TNBuilt 1975 · S/N CE-580N4464QTofteland Chad E · Westhope, NDS/N 18800864N4464WMantei & Associates Ltd · Lexington, SCBuilt 1974 · S/N E-543N4465SFtp LLC · Newington, CTBuilt 1975 · S/N E-693N4466LSmyrna Aviation LLC · Edgewater, FLBuilt 2000 · S/N E-3366N4466QSchindler Kelly J DBA · Billings, MTBuilt 1972 · S/N 18800866N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779N4466WPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 1973 · S/N TE-936N4467AWynn Andrew J · Montgomery, ALBuilt 1970 · S/N E-212N4467SK & M Leasing Inc · Camden, ARBuilt 1975 · S/N E-694N4468SKyle Robert K · Madison, MSBuilt 1975 · S/N E-696N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N4469WDietle Kurt D · Valley Springs, CABuilt 1974 · S/N CE-494N446ALValiair Lc Trustee · Casper, WYS/N CE-1137N446JRSpangler John T · Mount Pleasant, PABuilt 1974 · S/N CE-541N446MMInternational Air Services Inc Trustee · Carson City, NVS/N 4608006N446PCStatius-Muller Robert C Trustee · Stamford, CTBuilt 2006 · S/N 29-0446N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778N4471EWolfe John · Marathon, FLBuilt 2001 · S/N E-3394N4471RMurray Carol A · Hilo, HIBuilt 1976 · S/N 18502964N4474MN4474m Inc · Camarillo, CABuilt 2001 · S/N EA-674N4474STailwind Aviation LLC · New Rochelle, NYBuilt 1975 · S/N E-698N4474WR And S Aviation LLC · Corning, ARBuilt 1974 · S/N TH-431N4475ARyan Justin M Jr · Rch Palos Vrd, CABuilt 1970 · S/N TE-807
Back to AD 86-13-04 R3