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.

N529RGKarger Kenneth · Graford, TXBuilt 2005 · S/N 3255031N529RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1984 · S/N 60-8423004N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741N529VMCgm Aviation LLC · Gainesville, FLBuilt 1993 · S/N 14582N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089N52ATPowell Michael R · Anchorage, AKBuilt 1977 · S/N 1003N52BRed Baron LLC · Middletown, DEBuilt 1988 · S/N 8-0084N52BCCottle Kevin Patrick · Daniels, WVBuilt 2008 · S/N 011N52CAAllison Charles L · Park Rapids, MNBuilt 1993 · S/N 1335N52CLDannebrog Air LLC · Grand Island, NEBuilt 1971 · S/N 28R-7135042N52DAHusky Aero LLC · Grand Forks, NDS/N 2033N52DKPierson Janice Trustee · Scio, ORBuilt 1975 · S/N DE892N52DMPetersen Stephanie Ann Trustee · Coronado, CABuilt 1963 · S/N E3B-624-2224N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506N52DSGiaretta David · Arlington, TXBuilt 2009 · S/N 1107N52ERFly Safe Southwest LLC · Vail, AZBuilt 1979 · S/N AA5B1095N52EVPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054006N52FBForslin Jeremy · Prior Lake, MNBuilt 1973 · S/N 61-0132-071N52FCAccent 300 LLC · Opa Locka, FLBuilt 2003 · S/N 170N52FKSixgun Aviation LLC · Eddyville, KYBuilt 1991 · S/N 1122N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73N52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761N52GKLanthrum Joseph G · Port Hadlock, WABuilt 2002 · S/N 28015CN52GMSchneider Jeffrey A · Pensacola, FLBuilt 1973 · S/N 70-73N52GVCompass Aviation Maintenance LLC · Shelby, NCBuilt 1978 · S/N R18200393N52HFNorov Yury · Saint Augustine, FLBuilt 1964 · S/N 27-2568N52HMMead Charles Reese · Lake Havasu, AZS/N HM045N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466N52HYNorstegaard Brian M · Gillette, WYBuilt 2003 · S/N 2220N52JEAtkinson Holdings LLC · Kalispell, MTBuilt 1969 · S/N 61-0016N52JGMalloy Marc · Fletcher, NCS/N 670N52JHMonroe Scott E · Antelope, CABuilt 1981 · S/N 1N52JKHigh Alpha LLC · Miami, FLBuilt 1979 · S/N 61P06367963292N52JPBrush Wesley A · Sparks, NVBuilt 1983 · S/N 1235N52JQQuaid Jeffrey G · Paso Robles, CABuilt 2015 · S/N 70595N52JSSweeney Jack R · Parker, AZBuilt 1988 · S/N RAM 01N52KBRisjan Randy D · Westfield, NYBuilt 1995 · S/N 272N52KDWhite Taylor D · Gainesville, GABuilt 2016 · S/N 20465N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563N52KSDawson-Townsend Timothy M · Hingham, MAFirst renewal noticeBuilt 2010 · S/N 40025N52LCHarris Bill J · Evergreen, COBuilt 1992 · S/N 539N52LVAltair Aircraft LLC · Gainesville, FLBuilt 1971 · S/N MC-22N52LWN8138l LLC · Metairie, LABuilt 1999 · S/N 840-99N52MECopilots LLC · Ann Arbor, MIBuilt 2012 · S/N T20609062N52MRShealy Berry J · Augusta, GABuilt 1989 · S/N 1325N52NLMarauder Aviation LLC · Cheyenne, WYBuilt 2000 · S/N 109N52PDAviation Endeavors LLC · Houston, TXBuilt 1996 · S/N 807N52PGCrew And Mgt Svcs LLC · Union Lake, MIBuilt 1981 · S/N 6008678161247
Back to AD 87-10-06 R1