AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-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-10-06-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.

N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713N6539WYounglove Donald L · Mendota, ILBuilt 1965 · S/N 28-20618N653BQQuilty Stephen M · Abingdon, VABuilt 1968 · S/N 28-5055N653CHKelley Aviation Consultants LLC · S Williamsport, PABuilt 1965 · S/N 96-0653N653DFRv 10 LLC · Kalispell, MTS/N 40909N653FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020171N653JFRegistration Pending · Elizabeth, NJRegistration pendingBuilt 1992 · S/N 653N653KBSkyhawk Aviation Inc · Marietta, GABuilt 2000 · S/N 172S8686N653PSCorcoran Matthew L · Redondo Beach, CABuilt 2016 · S/N 70035N653QPhillips Robert B · Coshocton, OHBuilt 1959 · S/N TD-201N653RVRoberts Todd L · Friday Harbor, WABuilt 2002 · S/N 60503N653SHGivens Tyler · La Vernia, TXBuilt 2003 · S/N 3504N653SMMckinney Steven R · Hamersville, OHBuilt 1984 · S/N TRICE 0001N653SRVertex Aviation Services LLC · Burlington, WABuilt 1968 · S/N 17701048N653WChesebro Ben D · Oro Valley, AZBuilt 1998 · S/N 60053N653WWBerry Aviation Inc · San Marcos, TXBuilt 2005 · S/N T20608521N654Roderick Paul E · Talkeetna, AKBuilt 2016 · S/N 006N6540PStauffer Charles R · Pittsburg, MOFirst renewal noticeBuilt 1959 · S/N 24-1662N6540WRiggs Charles A · Pembroke Pines, FLBuilt 1965 · S/N 28-21266N65413John Mccaskill Enterprises LLC · Tifton, GAS/N 18281444N6541URegistered aircraftBuilt 1962 · S/N 2324N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482N6542PSmith Noland F Jr · Chattanooga, TNBuilt 1959 · S/N 24-1664N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765N6542WBaird Philip D · Judith Gap, MTS/N 28-21268N6542ZKingsley Kiman J · Miller, MOBuilt 1962 · S/N 25-2081N65431Caliber Capital Holdings LLC · Homosassa, FLBuilt 2004 · S/N T18208302N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543UGiesey William · Philadelphia, PABuilt 1962 · S/N 2326N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622N65445International Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N T18208322N6544AMatthews Aviation LLC · Hardinsburg, KYS/N 27-7954005N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365N65452Jf Aviation LLC · Minot, NDBuilt 2004 · S/N T20608491N65459Vitatoe Industries Inc · Chillicothe, OHBuilt 2004 · S/N T20608492N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581N6546FMiljour Jack A · Sanborn, NYBuilt 1976 · S/N 28-7790153N6546UBadlands Flyers Inc · Watford City, NDBuilt 1962 · S/N 2329N65472Registered aircraftBuilt 2004 · S/N 18281451N65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeBuilt 2004 · S/N T20608493N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990N6547SMiller Bradley J · Joliet, MTS/N 15067347N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036
Back to AD 87-10-06 R1