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.

N7194BBooker Louis E Jr · Pinetop, AZBuilt 1956 · S/N 22-4390N7194CCivil Air Support LLC · Phoenix, AZBuilt 1975 · S/N 28R-7635096N7194DBeacon West LLC · Billings, MTBuilt 1957 · S/N 18-5662N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894N7194KHolt Tommy · Big Lake, TXBuilt 2000 · S/N 3146N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494N7194RAltair Associates · Middletown, DEBuilt 1966 · S/N 28-21908N7194WWagner Jeffrey P · Bridport, VTBuilt 1963 · S/N 28-1006N7195EMn Helicopters Inc · Blaine, MNBuilt 2000 · S/N 3158N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495N7195VScherer Eric · Mooresville, NCBuilt 1975 · S/N 20-1147N7195WMueller Reinhard B · Sparta, WIBuilt 1963 · S/N 28-993N7195ZDenis Ranch · Vancourt, TXBuilt 2001 · S/N 3246N7196HState Of Alaska · Anchorage, AKBuilt 2001 · S/N 0994N7196LDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N AA5-0496N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496N7196RCrisler Capital LLC · Sunnyvale, TXS/N 28-21910N7196WJets To Helis LLC DBA · Chandler, AZBuilt 2000 · S/N 3140N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897N7197LMorris Gary M · Lucedale, MSBuilt 1974 · S/N AA5-0697N7197RTaylor Timothy T · Quitman, ARS/N 28-21911N7197VExecutive Helicopters Inc · Myrtle Beach, SCBuilt 1999 · S/N 0692N7197ZAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 3249N7198AFlying J Services LLC · Jourdanton, TXBuilt 2001 · S/N 3216N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898N7198JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3232N7198MMcelhannon Fayette M Jr · Athens, GABuilt 1990 · S/N 541RN7198NAero Leasing Inc · Medford, ORBuilt 2001 · S/N 3168N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498N7198RWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1966 · S/N 28-21912N7198VBrown Keane A · Portales, NMS/N 21-1162N7198ZPiedmont Soaring Society · Clemmons, NCBuilt 1964 · S/N 25-3095N7199Big Sky Flyers LLC · Billings, MTBuilt 1971 · S/N 419FN7199KMountain Mind Media LLC · Palmer, AKBuilt 1950 · S/N 18-222N7199PLee Jeffrey L · Cameron, MTBuilt 1961 · S/N 24-2370N7199RBrendemuhl Nathan C · Everett, WAS/N 28-21914N7199WBobkat Aviation LLC · Louisville, KYS/N 281074N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223N719ACZing Aviation And Marine LLC · Edgewater, FLBuilt 2001 · S/N 1314-2001N719AHBanz Charles M · Stuart, FLBuilt 2004 · S/N 70499N719AMMoses Adrian J · Lake Lotawana, MOBuilt 2010 · S/N 40136N719APPeros Dino · Pipersville, PABuilt 1981 · S/N 2245N719CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281714N719DDCottrell Mark C · Leitchfield, KYS/N 206N719DFDubroc Marcus C · La Place, LABuilt 1975 · S/N 287510046N719GWWayne Alan A · Flowery Branch, GABuilt 1989 · S/N 1809034N719HHHill James P · Eagle Point, ORBuilt 2008 · S/N SR-122N719HWPettis Aviation LLC · Mckinney, TXBuilt 2009 · S/N 72868
Back to AD 87-10-06 R1