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.

N711WDSeawind Adventures LLC · Reno, NVBuilt 2004 · S/N 51N711WEMelbourne Flight Training LLC · Melbourne, FLS/N 17272616N711WZBaker Matthew · Mesa, AZBuilt 1990 · S/N 27-0042N711XCFore Shannon Richard · Wasilla, AKBuilt 2016 · S/N CC19-0009N711YAStegmann Scott A · Port Orange, FLBuilt 1995 · S/N 235N711YCIturriria John M · Kuna, IDFirst renewal noticeBuilt 2005 · S/N 0023N712Oman Lee · Sequim, WAS/N 399N7120DWeiss James R · Westlake, OHBuilt 1957 · S/N 22-4980N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820N7120LTschirhart Larry S · San Antonio, TXBuilt 1974 · S/N AA5-0620N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420N7120VOpulent Investments LLC · Mandan, NDBuilt 1974 · S/N 21-0043N7120YRoyal Ryan M · Lincoln, NEBuilt 1963 · S/N 30-139N7121DBohrman Robert C · New Berlin, WIBuilt 1957 · S/N 22-4981N7121PLecren Douglas · Wasilla, AKBuilt 1958 · S/N 18-7121N7121YUhlemeyer William A · Alvin, TXBuilt 1963 · S/N 30-140N7121ZQuality Aviation Inc · Marana, AZS/N 25-2920N7122AContinental Helicopters Inc · Sheffield, TXBuilt 1999 · S/N 2956N7122BCgu Aviation LLC · Naples, FLBuilt 1956 · S/N 22-4340N7122EChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 4496447N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822N7122JCarrizales Chad A · Jacksonville, ARBuilt 1973 · S/N 32-7300032N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7122VProvance Brent L · Granbury, TXBuilt 1974 · S/N 22-0051N7122YSutton Jack M · Jesup, GABuilt 1963 · S/N 30-141N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823N7123PMclenaghan Alvain N · Phoenix, AZBuilt 1961 · S/N 24-2283N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624N7124PTalley John T · Clifton, TXFirst renewal noticeBuilt 1961 · S/N 24-2284N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124UGoss Brendan · Shady Shores, TXS/N 363N7124VHunter Cameron Brooks · Keller, TXBuilt 1974 · S/N 22-0053N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125DWarrior Creek Adventures LLC · Moultrie, GABuilt 1981 · S/N A7360CN7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425N7125PHernandez Jimmy Lee · Lamesa, TXBuilt 1961 · S/N 24-2286N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125UTakacs Robert S · Oxford, CTBuilt 1964 · S/N 364N7125VSutphen James A · Henderson, TXBuilt 1974 · S/N 22-0054N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N71266Kuhtenia David G · Galena, OHBuilt 2016 · S/N 60355N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126GHenry Rolla G Jr · Saint Charles, MOBuilt 1966 · S/N 30-1001N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7127RGreen William A · Memphis, TNS/N 28-21828
Back to AD 87-10-06 R1