OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N131CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881353N131CBBoswell Carter H Jr · Sahuarita, AZBuilt 1998 · S/N 1119N131CMMagnolia Air LLC · Warrenton, VABuilt 2004 · S/N 81037N131CWLauridsen Hans O · Scottsdale, AZS/N 54-2809N131DBBerlin Donald D · Tucson, AZBuilt 2014 · S/N 209N131DPLe Reve Aviation LLC · Norfolk, VABuilt 1957 · S/N 23-1044N131DRMills Robert V · Georgetown, TXS/N E3B631N131DWWeitz David M · Caldwell, IDBuilt 2015 · S/N 569-2015N131ESEngland Charles E · Jackson, MSBuilt 2004 · S/N 24972N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097N131FDDill James G · Gainesville, TXBuilt 1947 · S/N 146N131FHAnderson Keith C · Puyallup, WABuilt 1954 · S/N 1011N131FJHuerta Jesse A · Burleson, TXBuilt 2002 · S/N H-03N131FROptic Air LLC · Sioux Center, IAS/N 17276252N131GSStanley Gerald L · Littleton, COBuilt 1999 · S/N 839-99N131HSDanford Scott M · Chickamauga, GAS/N 230N131JB47 Alpha LLC · North Andover, MABuilt 2017 · S/N CC19-0020N131JCCain Jeffrey B · Godley, TXBuilt 2020 · S/N BU131-1N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668N131JFShevlin Graham D · Duncanville, TXBuilt 1994 · S/N H-02N131JHCampbell Steven E · Fayetteville, TNBuilt 2005 · S/N 5343N131JLIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1970 · S/N 225N131JMMoffitt John S · Gilroy, CABuilt 2001 · S/N 2150N131JTCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1468-166N131KYJett Edward C Jr · Bloomfield, KYBuilt 1979 · S/N AA5A0828N131LDSatin Legal Inc · Rio Linda, CABuilt 1998 · S/N 313N131LHObreiter Robert Jr · Simi Valley, CABuilt 1993 · S/N 20781N131LLAims Community College · Greeley, COBuilt 2020 · S/N 2881345N131LRCharles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7425258N131LSHawthorne Neil · Anchorage, AKBuilt 1999 · S/N 059N131MRKing Andrew D · Elkwood, VABuilt 1954 · S/N 468N131NOneal Gary · Springdale, ARBuilt 1947 · S/N TTN-65N131PAAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020055N131PFFontaine Peter · Fletcher, NCBuilt 2023 · S/N 106N131PHMori Glenn E · West Ossipee, NHS/N 20014CN131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030N131PMDodge Sean · Littleton, NHS/N 462-2004N131RReno Noah J · University Place, WAS/N 061N131RBLochman Construction LLC · Prosper, TXBuilt 1994 · S/N 2190N131RCNordman Clay DBA · Catheys Valley, CAFirst renewal noticeBuilt 1996 · S/N 376-96N131RGGillen Justin L · Palmdale, CABuilt 2012 · S/N 025N131RJEggleston William A · Wayland, MABuilt 1974 · S/N 28-7415665N131RLLeads Air Inc · Dover, DEBuilt 1989 · S/N 4622048N131RMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 27-7654053N131SMurphy Edward S · Zephyrhills, FLS/N 131N131SCSum Livestock LLC · Ekalaka, MTS/N 18-7609060N131SEHouseman Steven · Chillicothe, OHBuilt 2006 · S/N 490-2006N131SGPrewitt Thomas R · Hope Mills, NCBuilt 2002 · S/N 1324-2002N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070N131UCrawford Edward J DBA · Saint Louis, MOBuilt 1993 · S/N 10163
Back to AD 87-10-06 R1