OpenAirDocs.org
AD 87-22-02 R1

Registered aircraft · 303

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-22-02-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-22-02-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 586N105UTobago Six Inc · Bellevue, WAS/N 591N106FI A Lele LLC · Great Falls, VAS/N 592N107FRjm Aviation Partners Inc · Naples, FLBuilt 1986 · S/N 599N107VJdj Endeavours LLC · Downers Grove, ILBuilt 1986 · S/N 601N108YGoduto Aeronautics LLC · Monroe, CTS/N 594N110UDarnell Charlie · Eads, TNS/N 595N112ADfss LLC · Henderson, NVS/N 602N112VLebanon Valley Mobile Homes Inc · Palmyra, PAS/N 605N113ACInternational 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 2028N115JHanson John Eric · Livermore, CABuilt 1986 · S/N 607N115JRTobago4 LLC · Lawrenceville, GABuilt 1989 · S/N 937N115NSprauer Constance D · Kensington, NHS/N 608N1188RAirtrust LLC - 2 - Series 2 Trustee · Sheridan, WYS/N 2200N11VDQualitair LLC Trustee · MichelstadtS/N 2052N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206N135DDEuroaviation Inc Trustee · KematenS/N 2207N138RJBayou Flight Training LLC · Niceville, FLBuilt 1988 · S/N 821N146MWMehling Kevin E · WiesbadenBuilt 1984 · S/N 0389N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020N151AMacnealy Gregory A · Vandalia, OHS/N 764N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005N1625LArtime Jorge Daniel · Miami Beach, FLBuilt 1979 · S/N 13N165GTMckeon 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 2022N189TBPacca Club Inc · Attleboro, MAS/N 891N1903SGriffin 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 2023N197TBHardman Andrew D · Prosper, TXS/N 1806N198SAAbel Air LLC · Dorchester, MABuilt 1998 · S/N 1836N200STk Aviation LLC · Willow Street, PAS/N 609N204MEArgo Aviation Inc Trustee · Wilmington, DEBuilt 1989 · S/N 909N204YUFly Invest Inc Trustee · Wilmington, DEBuilt 1989 · S/N 910
Back to AD 87-22-02 R1