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.

N7256HChaparral Aviation LLC · Edmond, OKBuilt 1999 · S/N 18280556N7256QAustin Ferrel Stephen · West Monroe, LABuilt 1999 · S/N 18280552N7256WRoswall James B · Bristol, TNBuilt 1999 · S/N 18280507N7256YGupta Vivek · Shelton, CTBuilt 1999 · S/N 18280485N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593N7257DArctic Aero LLC · North Pole, AKBuilt 1957 · S/N 22-5084N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760N7257FHedberg Jacob R · Jordan, MNS/N 28-25175N7257JHardin John M · Terrell, TXBuilt 1968 · S/N 28-24601N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508N72582Surdex Corp · Chesterfield, MOFirst renewal noticeBuilt 1999 · S/N T20608114N72588Seidel Roland · Azle, TXBuilt 1963 · S/N TD-532N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063N7258DVandemerwe Rilyn Grant · Durango, COBuilt 1957 · S/N 22-5085N7258FCochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 28-25177N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291N7258ZGraber Jesse B · Northfield, MNBuilt 1999 · S/N T20608113N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064N7259FLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1976 · S/N 28-7715205N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559N7259VKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1967 · S/N 1313N725AN725a LLC · Manassas, VABuilt 2000 · S/N 0105N725ACFiorini Jay · Turlock, CABuilt 1999 · S/N 1254-98N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802N725BJBas Part Sales LLC · Greeley, COS/N 20608023N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821N725CAScaled Vantage LLC · Olathe, KSBuilt 2024 · S/N 41935N725CBRenner David M · Longview, WABuilt 2003 · S/N 884N725CMScholz Mark W · Atchison, KSBuilt 1997 · S/N 794-97N725DBMang Joseph K · West Des Moines, IABuilt 1976 · S/N AA5A-0126N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842N725ESKovasckitz Michael J · Cincinnati, OHBuilt 2003 · S/N 25629N725GALendor David A · Jersey City, NJBuilt 1978 · S/N GA7-0024N725GMPyke Gregory A · Graham, WABuilt 2014 · S/N 1001N725HEOtt Edward C · Walnut Creek, CABuilt 2000 · S/N 441-2000N725JKAlkay Flight LLC · Lewes, DEBuilt 1988 · S/N 7480CN725JMRegistered aircraftBuilt 1997 · S/N 798-97N725NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881620N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254N725RSHandwerk William C · Georgetown, TXS/N 27-0026N725RVEmery Marilyn Laverne · Randle, WABuilt 1987 · S/N 725N725SMS&M Aviation LLC · South Boston, VABuilt 2000 · S/N 0754N725TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 2201N725YPMilton John L · Heathsville, VABuilt 2000 · S/N 25064CN725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734
Back to AD 87-10-06 R1