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.

N20AGInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 2003N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLS/N 581N20DUWings Of Hope · Chesterfield, MOBuilt 1985 · S/N 529N20DXBig Sur USA LLC · Boca Raton, FLS/N 613N20DYBpw Aviation LLC · Huntsville, ALS/N 614N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20ELJrhav LLC · Chassell, MIS/N 622N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621N20EUWerking John William III · New Windsor, MDS/N 628N20FKJohnston Brian · Bethany Beach, DES/N 637N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638N20FRNorton Justin William · Albuquerque, NMS/N 639N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20FZSharp 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 655N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558N20KNShaw William C · Carmel, NYS/N 682N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LUCamas Wings LLC · Camas, WAS/N 685N20LVSilver Skyways LLC · Las Cruces, NMBuilt 1986 · S/N 686N20NBStauffer Michael S · Wichita Falls, TXS/N 557N20NCJohnson Professional Aviation LLC · League City, TXS/N 559N20NDSheff Donald · Redwood City, CAS/N 687N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008N20TKVanguard Executive LLC · Elfers, FLBuilt 1987 · S/N 748N20TLN20tl 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 2214N2188AAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 2188N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695N21AJAllcroft Roger A · Haydenville, MAS/N 754N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755N221AMOctopus Flying Club Inc · Riverdale, MDBuilt 1998 · S/N 1856N228GHopkins Boone K · Saint Simons Is, GAS/N 612N229TBRegistration Pending · Chicago, ILRegistration pendingS/N 1229N241GTBroshchan Ruslan A · Jackson, MSS/N 2141N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042N242ZZSpace Coast Aircraft Co · Merritt Island, FLS/N 2080N245LCImage Craft LLC · Phoenix, AZBuilt 2001 · S/N 2045N24TAN24ta LLC · Wilmington, DEBuilt 1984 · S/N 457
Back to AD 87-22-02 R1