AD 95-26-16 R1

Registered aircraft · 1,406

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:95-26-16-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:95-26-16-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.

N50RSStone Raymond J · Felton, DEBuilt 1977 · S/N 24-0177N511MSBarrow Justin · Santa Fe, TXBuilt 1992 · S/N 24-3262N51AMKerns Joshua S · Leander, TXBuilt 1978 · S/N 24-0430N5201CCordero Jose Robert · El Paso, TXBuilt 1978 · S/N 24-0577N5201DGriffin Thomas S · Spartanburg, SCBuilt 1978 · S/N 24-0578N5201LMelchiorre Joseph G Jr · Milton, DEBuilt 1978 · S/N 24-0580N5201NMarr Christopher M · Morrisville, NCBuilt 1978 · S/N 24-0581N5201UMccrary Enterprises LLC · Port Jefferson, OHBuilt 1978 · S/N 24-0582N5201VMg Aircraft Inc · Fort Lauderdale, FLBuilt 1978 · S/N 24-0583N5201XSims Raymond H · Navarre, FLBuilt 1978 · S/N 24-0584N5201YShared Momentum LLC · Wilmington, DEBuilt 1978 · S/N 24-0585N5211ZFlightwerx Inc · Deland, FLS/N 24-1653N5215ADrake James R Jr · Lawrenceville, NJBuilt 1988 · S/N 24-1657N5216EHerrera Teodoro Humberto · El Paso, TXBuilt 1988 · S/N 24-1658N521SFCarey Kevin · Brighton, MAS/N 24-3191N523JSOlson Jon II · Drake, NDBuilt 1993 · S/N 24-3305N5240UEllison Bradley B · Condon, MTS/N 24-3087N52481Wings N Gold LLC · Lewes, DES/N 24-3089N5249UPixley Andrew Don-George II · Rochester Hills, MIBuilt 1989 · S/N 24-3090N524RAMiller Seth · Lafayette, INS/N 24-3088N52503Mooney 52503 Flyers · San Diego, CAS/N 24-3091N5254NOrbelo Robert W · Farmington, NMS/N 24-1663N5254TMillion Air LLC · Las Vegas, NVS/N 24-3093N5255SAkc III Aviation LLC · Port Saint Joe, FLS/N 24-1655N5257QNott Michael A · Lake Havasu City, AZS/N 24-3074N5257TLangel Michael L · Huntington Beach, CAS/N 24-1661N5258GMooney N5258g LLC · Kalispell, MTS/N 24-1662N5259CMcsorley John A · North Augusta, SCS/N 24-3094N52611Ronnau James F · Overland Park, KSS/N 24-1665N5262AMcgowen Douglas R · Virginia Beach, VAS/N 24-1666N5262FRegistered aircraftBuilt 1988 · S/N 24-1667N52641Birk Aviezer · Saint Augustine, FLS/N 24-1668N52646Lobianco John · Woodmere, NYS/N 24-3081N526SAGumps LLC · Jersey City, NJBuilt 1984 · S/N 24-1498N5270WReigle Tom J · Madison, NES/N 24-3082N5272KGarmin International Inc · Salem, ORBuilt 1988 · S/N 24-1670N5275TLisenby Joseph W Jr · La Conner, WAS/N 24-1676N527RJGonzales Denise E · Fort Worth, TXBuilt 1996 · S/N 24-3382N5280JKnopp Kenneth J · Nashua, NHS/N 24-1679N52840N52840 LLC · New York, NYFirst renewal noticeBuilt 1988 · S/N 24-1683N52848Danzig Solomon · Alpharetta, GAS/N 24-1684N5288GC&B Air Services LLC · Wilmington, DES/N 24-1641N529PAPaccone John E · La Canada, CAS/N 24-1659N531DDPratt Bruce C · Sausalito, CABuilt 1980 · S/N 24-0948N531DELand Farming Inc · Kulm, NDBuilt 1984 · S/N 24-1449N53RHRoyal Blue Medical Inc · Hanceville, ALBuilt 1977 · S/N 24-0234N547DWWasser Thomas · Lyons, NYBuilt 1989 · S/N 24-3134N54ERKhandpur Rajiv K · Hicksville, NYBuilt 1982 · S/N 24-1305N555EDPoteet-Schwartz Kim L · Albuquerque, NMS/N 24-0684N558MSynergyair Ltd · Lewis Center, OHS/N 24-1686-14
Back to AD 95-26-16 R1