OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027N17785Registered aircraftBuilt 1977 · S/N E-1025N17791Spuza Dan D · Sanger, TXBuilt 1977 · S/N CE-708N17794Getting Dean W · Fort Dodge, IABuilt 1977 · S/N E-1029N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010N177ABKostroski Larry J · Tucson, AZBuilt 1972 · S/N TE-873N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N177SWGruslin Jean Pol G · Kingwood, TXBuilt 1975 · S/N E-731N17802Asxo · Dallas, TXBuilt 1977 · S/N CE-709N17814Sellers Scott · Solsberry, INBuilt 1978 · S/N D-10144N17816Legal Flying Service Inc · Pembroke Pines, FLBuilt 1977 · S/N D-10011N17817Dye Barrett · Abilene, TXBuilt 1977 · S/N E-1034N17818Batie Gregory T · Rogers, ARBuilt 1977 · S/N CE-710N17819Mclendon Brian · Hawkins, TXBuilt 1977 · S/N E-1035N17820Evergreen Flying Service Inc · Rayville, LABuilt 1977 · S/N TE-1101N17826Three Six Bonita LLC · Georgetown, TXBuilt 1977 · S/N E-1036N17827Cumins Douglas · Mechanicsville, VABuilt 1977 · S/N D-10015N17829Slayden Wesley B · White Bluff, TNBuilt 1977 · S/N CE-712N17832Arrow Inc · Mount Sterling, KYBuilt 1977 · S/N E-1039N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827N17836Bear Dorvin L · Elida, OHBuilt 1977 · S/N E-1041N17838N17838 LLC · Scottsdale, AZBuilt 1977 · S/N E-1046N17840Es Investments LLC · Chandler, AZS/N D-10017N17846Stalford Tom G · Nicholson, PABuilt 1977 · S/N CE-714N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58N17852Flores Gustavo · Dallas, TXBuilt 1977 · S/N CE-715N17863Loon Song Flyers LLC · Brookside, NJBuilt 1977 · S/N E-1055N17865Wcs Inc · Troy, ALBuilt 1977 · S/N D-10021N17931Unlimited Sky LLC · Swansboro, NCBuilt 1977 · S/N E-1022N1794WSkyhawk Flying Club Inc · Omaha, NEBuilt 1972 · S/N E-380N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840N17988Gonneville Donald E Jr · Durango, COBuilt 1977 · S/N D-10026N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372N17CCReinhart Alan · Ventura, CABuilt 1969 · S/N D-9087N17CDDroddy Charles V · Bryan, TXBuilt 1976 · S/N E-931N17EARegistration Pending · Melbourne, FLRegistration pendingBuilt 1997 · S/N E-3092N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488N17FECox Matthew B · Russiaville, INBuilt 1979 · S/N D-10280N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210
Back to AD 87-18-06 R1