OpenAirDocs.org
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.

N5532SAks Aviation LLC · Arroyo Grande, CABuilt 1980 · S/N R18201598N5532UGorman Jeremy J · Chapman, KSBuilt 1969 · S/N 28-26249N55330Eaw Aviation LLC · Middletown, MDBuilt 1973 · S/N 28R-7335218N55331Scholl Oil & Transportation Company · Holyoke, COBuilt 1973 · S/N 28-7310128N55338Pt Arts LLC · Grand Rapids, MIBuilt 1973 · S/N 28-7325370N5533FCopenhaver Ralph L · Brady, TXBuilt 1968 · S/N 28-24876N5533PRado Richard L · Fortville, INBuilt 1958 · S/N 24-597N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955N5533RThompson Aaron R · Louisville, KYS/N 172RG0072N5533SNgb Construction Inc · Ceres, CAS/N R18201599N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183N55345Arrow Flite LLC · Chino Hills, CABuilt 1973 · S/N 28R-7335220N55347Roze Scott L · Port Orange, FLBuilt 1973 · S/N 28-7310129N55349Mob Aviation LLC · Auburndale, FLS/N 17275163N5534ELindsey Kelly M · Throckmorton, TXBuilt 1978 · S/N 17271883N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78N5534QPaul Richard W · San Jose, CABuilt 1965 · S/N 620N55350Haps Air Inc · Ames, IABuilt 1982 · S/N 17275164N55359Uribe Roberto · Houston, TXBuilt 1973 · S/N 28R-7335222N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934N5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 32-998N5535KHays Cory · Beaumont, TXBuilt 1978 · S/N 390-78N5535MButz Jonathan O · Mansfield, OHBuilt 1967 · S/N 121N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956N55360Ball Duke Allen · Drakesville, IABuilt 1973 · S/N 32-7340113N55363Hardin John M · Terrell, TXS/N 34-7350206N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384N5536EJeffries And Hendley LLC · Greenwood, INBuilt 1978 · S/N 17271885N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935N5536JHanna Patricia A · Davis Junction, ILS/N 32-999N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600N5536QWokini Air LLC · Tarpon Springs, FLS/N 621N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257N5536WSchilke Kenneth · Imperial, NES/N 28-626N55372Mccarroll Daniel C · Saint Augustine, FLS/N 1188N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170N55378Iacobacci Timothy · Fairborn, OHBuilt 1973 · S/N 34-7350207N5537KSales First LLC · Jasper, GABuilt 1978 · S/N 392-78N5537MWiglesworth David G · Lenexa, KSBuilt 1967 · S/N 123N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073N5537SMcpeak Alan W · Colorado Springs, COBuilt 1980 · S/N R18201600N55380Clark Joseph David · Kilgore, TXS/N 28-7325388N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371N55386Redlands Flying Club · Redlands, CAS/N 1189N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78N5538QDurkee Brenton J · Brooklyn, NYBuilt 1965 · S/N 622
Back to AD 87-10-06 R1