OpenAirDocs.org
AD 87-12-09 R1

Registered aircraft · 250

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:87-12-09-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-12-09-R1')
  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 2121N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N115DSOverly Christopher Daniel · Williamsport, OHBuilt 2000 · S/N 2028N11VDQualitair LLC Trustee · MichelstadtS/N 2052N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206N135DDEuroaviation Inc Trustee · KematenS/N 2207N146MWMehling Kevin E · WiesbadenBuilt 1984 · S/N 0389N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005N165GTMckeon 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 1887N1888EChoe Young Kyu · Manhasset, NYBuilt 1999 · S/N 1888N188GTI&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 1894N189GTKenai Aviation LLC · Akron, OHBuilt 2001 · S/N 2022N1903SGriffin Products Inc · Wills Point, TXBuilt 1999 · S/N 1903N1906SMiskovic Dejan · San Jose, CABuilt 1999 · S/N 1906N1909SDennerline Rhett R · Northfield, ILBuilt 1999 · S/N 1909N190AVNghiem Daniel · Westminster, CAS/N 2165N190GTRincon 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 637N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638N20FRNorton Justin William · Albuquerque, NMS/N 639N20FZSharp Randy L · Rocklin, CABuilt 1986 · S/N 644N20GFVerbil Christopher J Trustee · Los Altos, CABuilt 1987 · S/N 645N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LUCamas Wings LLC · Camas, WAS/N 685
Back to AD 87-12-09 R1