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.

N463DMGresham Stanley W DBA · Ironwood, MIBuilt 1995 · S/N 801N463DSSalisbury David W · Gettysburg, PABuilt 2005 · S/N 1518N463FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020063N463HPBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4636335N463JPJj Hughes Logistics LLC · Canyon, TXBuilt 1999 · S/N 4636216N463RNDave Aviation LLC · Naperville, ILBuilt 1971 · S/N 28R-7135050N463SPRegistered aircraftBuilt 2000 · S/N 172S8370N46401Bandstra Larry J · Heath Springs, SCBuilt 1968 · S/N 17257242N46404Coastal Fliers Inc · El Cajon, CABuilt 1968 · S/N 17257244N46407Solis Joseph G · Poulsbo, WAS/N 17257246N4640J4 Flyers Inc · Norwood, NYS/N 17273657N4640RSchotter Robin J · Seattle, WABuilt 1966 · S/N 28-21393N4640VHbhis LLC · Gnadenhutten, OHBuilt 1978 · S/N VAC-95-78N4640WBerger Adam · Kanab, UTBuilt 1977 · S/N 13170N46410Valentine Terence · Glennallen, AKS/N 17257249N46415Hage Michael J · The Villages, FLBuilt 1968 · S/N 17257252N46418Batesquire LLC · Clanton, ALS/N 17257254N46419Rodgers Bruce W · Ramona, CABuilt 1968 · S/N 17257255N4641JN4641j LLC · Mulberry, FLBuilt 1968 · S/N 28R-30531N4641QFitzsimons Nicholas T · Covington, LABuilt 1973 · S/N 17261733N4641RWebb Patrick S · Chuckey, TNBuilt 1966 · S/N 28-21394N46420Frontier Environmental Solutions Inc · Inyokern, CAS/N 17257256N46423Parrish Aviation Flight Academy LLC · Southlake, TXS/N 17257259N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78N4642WHash Marshall W · Crumpler, NCS/N 13172N4642YFriends Aviation Inc · Wilmington, DEBuilt 1967 · S/N 25-4361N46430J & Dk LLC · Overland Park, KSBuilt 1968 · S/N 17257263N46433Plummer Fred C · Normal, ILBuilt 1968 · S/N 17257264N46435Hawkins County Sports Wings Inc · Kingsport, TNBuilt 1968 · S/N 17257266N46436Aero Science International LLC · Martinez, GABuilt 1968 · S/N 17257267N46437Arizona Active Air LLC · Yuma, AZBuilt 1968 · S/N 17257268N46440Engelskirger Karl D · Valley City, OHS/N 17257270N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277N4644JWinslow Francis E III · Raleigh, NCS/N 17273659N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78N4644YState Of Montana · Helena, MTBuilt 1971 · S/N 18-8945N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399N4645WClimb Maintain LLC · Morrisville, MOBuilt 1977 · S/N 13175N4646Bailey Christopher J · Riga, MIBuilt 1975 · S/N M-II-480N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400
Back to AD 87-10-06 R1