OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N280HRMussen Gary L · Exeter, CABuilt 1995 · S/N 32N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498N280JSStefanini Joseph M · Akron, OHS/N 1510N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329N280LASeipp Stephen C · Laurel, DEBuilt 1999 · S/N 2085N280MMrr Spraying LLC · Shelby, MTFirst renewal noticeS/N 749N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004N280MBWeber Donald E · St David, AZBuilt 1975 · S/N 3255N280MHGulf Coast Helicopters Inc · Pearland, TXBuilt 1988 · S/N 2022N280MLLundy Michael · Stephenville, TXS/N 2032N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280NARohner Harlan G · Willmar, MNS/N 2058N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070CN280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803N280SHRottor Aviation LLC · Jasper, INBuilt 2003 · S/N 2095N280SMAirpark Aviation LLC · Manchester, NHBuilt 1999 · S/N 2083N280TCNobles Gary D · Fairview, TXS/N 28-21227N280YSCrabtree Martin L · Sedalia, MOS/N BING-1N28103Hawksyntketics LLC · Jacksonville, FLS/N 78-31150N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N28119Page Gregory G · Roosevelt, UTBuilt 1978 · S/N 78-31146N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812VKennison Daniel J · Las Vegas, NVFirst renewal noticeS/N 1084N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2812YThor And Associates Inc · Montgomery, TXBuilt 1991 · S/N 1142N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052N28138Todd Jared · Victoria, TXBuilt 1977 · S/N 78-31142N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182N2814PSargent Wayne M · Bremerton, WABuilt 2002 · S/N WS1N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728N2815FKlopping William E · Apple Valley, CAS/N 28-7916438N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78N28160Sobol Anthony J · Sandia Park, NMBuilt 1979 · S/N 79-31153N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297
Back to AD 87-10-06 R1