OpenAirDocs.org
AD 86-17-03

Registered aircraft · 200

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-17-03')
    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-17-03')
  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.

N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585N104EHaas Bruce F · Lynden, WAS/N 586N108YGoduto Aeronautics LLC · Monroe, CTS/N 594N110UDarnell Charlie · Eads, TNS/N 595N112ADfss LLC · Henderson, NVS/N 602N113ACInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 2121N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N115DSOverly Christopher Daniel · Williamsport, OHBuilt 2000 · S/N 2028N11VDQualitair LLC Trustee · MichelstadtS/N 2052N135DDEuroaviation Inc Trustee · KematenS/N 2207N146MWMehling Kevin E · WiesbadenBuilt 1984 · S/N 0389N165GTMckeon Aviation Leasing-N165gt LLC · Wilmington, DEBuilt 2001 · S/N 2075N166GTRobinson David S Jr · King William, VABuilt 2000 · S/N 2006N168GTN168gt LLC · Newbury Park, CABuilt 2000 · S/N 2018N1711SAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1711N1866SAviation Addiction LLC · Fishers, INBuilt 1998 · S/N 1866N1871SGreen Evan R · Calabasas, CABuilt 1998 · S/N 1871N1887SCavort LLC · New York City, NYBuilt 1999 · S/N 1887N188GTI&F LLC · Overland Park, KSBuilt 2001 · S/N 2048N1893SSylvester Donald W · Santa Maria, CABuilt 1999 · S/N 1893N1894SCravey Equipment Leasing LLC · Kerrville, TXBuilt 1999 · S/N 1894N1906SMiskovic Dejan · San Jose, CABuilt 1999 · S/N 1906N1909SDennerline Rhett R · Northfield, ILBuilt 1999 · S/N 1909N190GTRincon Gabriel · Baton Rouge, LABuilt 2001 · S/N 2023N198SAAbel Air LLC · Dorchester, MABuilt 1998 · S/N 1836N204MEArgo Aviation Inc Trustee · Wilmington, DEBuilt 1989 · S/N 909N204YUFly Invest Inc Trustee · Wilmington, DEBuilt 1989 · S/N 910N20AGInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 2003N20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLS/N 581N20DXBig Sur USA LLC · Boca Raton, FLS/N 613N20DYBpw Aviation LLC · Huntsville, ALS/N 614N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20FKJohnston Brian · Bethany Beach, DES/N 637N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20KPHulsey Ryan A · Cleveland, GAS/N 683N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008N20TLN20tl LLC · Incline Village, NVBuilt 1987 · S/N 749N20VCDanny J Daigle LLC · Greenville, MES/N 782N20VTRegistered aircraftS/N 899N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755N221AMOctopus Flying Club Inc · Riverdale, MDBuilt 1998 · S/N 1856N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042N242ZZSpace Coast Aircraft Co · Merritt Island, FLS/N 2080N24TAN24ta LLC · Wilmington, DEBuilt 1984 · S/N 457N2501NMarch Peter J · Peotone, ILS/N 900
Back to AD 86-17-03