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.

N610UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020166N6110AState Of Montana · Helena, MTBuilt 1979 · S/N 18-8009050N6110CLueck Taylor W · Wasilla, AKBuilt 1987 · S/N 4049CN6110WZimmerman David A · Memphis, TNBuilt 1964 · S/N 28-20125N6110XVitale Matthew W · Lithia Springs, GAS/N M-2347N6111DAdventure Flight LLC · Duchesne, UTBuilt 1956 · S/N 22-4755N6112JColeman Timothy Lynn · Port Charlotte, FLBuilt 1976 · S/N 28-7690342N6112PBurnett Jennifer · Palmer, AKS/N 24-1212N6112SHall Metal Corp · Fort Pierce, FLBuilt 1980 · S/N R18201615N6112WRoberts Jackie P · Bangs, TXBuilt 1964 · S/N 28-20127N6113JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690343N6113NKrabill Ronald D · Halsey, ORBuilt 1969 · S/N M-1199N6113RColorado Northwestern Community College · Rangely, COBuilt 1979 · S/N 172RG0086N6113VLegacy Lsa LLC · Plainview, TXBuilt 1980 · S/N 172RG0581N6113WMurray Brian C · Jonesboro, ARS/N 28-20128N6114NSabourin David R · Draper, UTBuilt 1969 · S/N M-1200N6114PCompton Mark E · Garfield, KYBuilt 1959 · S/N 24-1214N6114SGoral William W · Redlands, CABuilt 1980 · S/N R18201616N6114WGottschalk William R · Fort Atkinson, WIBuilt 1964 · S/N 28-20129N6114XHardy Gareth R · Thatcher, AZBuilt 1960 · S/N 500B-924-9N6114YFlies Warren E · Mesa, AZBuilt 1988 · S/N 11043CN6115DGeske Robert L · Enderlin, NDBuilt 1956 · S/N 22-4759N6115SGan Specialties Inc · Pocatello, IDBuilt 1980 · S/N R18201617N61160Hat Creek Holding Company LLC · Bellville, TXBuilt 1990 · S/N 10076CN6116JGlobal Technical Services Inc · Fort Worth, TXBuilt 1976 · S/N 28R-7635299N6116WKlyder Thomas A · Inverness, FLS/N 28-20131N6117PFriesen Aiden · Grants Pass, ORS/N 24-1217N6117WRoesler Robert D · Gordonsville, VAS/N 28-20132N6118DAtkinson James A · Bouse, AZBuilt 1957 · S/N 22-4762N6118PNovak Mark S · Dawson, NEBuilt 1959 · S/N 24-1218N6118WPiekielek John L · Punxsutawney, PABuilt 1964 · S/N 28-20133N6119DMeyer Robert M · Lancaster, NYBuilt 1956 · S/N 22-4763N6119PModisette Jeremy W · Baldwin, GABuilt 1959 · S/N 24-1219N6119VN6119v LLC · Boca Raton, FLBuilt 1995 · S/N 14629N611ADValiair Lc Trustee · Casper, WYBuilt 2003 · S/N T18208196N611ALMaverick Management Montana LLC · Yarmouth Port, MABuilt 2001 · S/N 5396N611APDobry Robert S · Crescent City, FLBuilt 1979 · S/N 317-79N611BDClement Aviation Inc · Tea, SDS/N 17266692N611BRKnick Michael J · Camarillo, CABuilt 1969 · S/N 700033N611CAWilliams Todd A · Littleton, COBuilt 1977 · S/N 17269022N611DGMiller Stephen James · Shreveport, LABuilt 1993 · S/N 27-0156N611DMFildes Robert · Troy, MOBuilt 1976 · S/N 001-RMN611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040N611DWNav Solutions LLC · Lewes, DEBuilt 1961 · S/N 500B-1099-60N611DXRegistered aircraftBuilt 1967 · S/N 149N611EAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1979 · S/N 17272471N611EVAero Activities LLC · Edgewood, NMBuilt 1993 · S/N 611N611FLZipp Nicole E · Raleigh, NCBuilt 1971 · S/N 28-7125489N611FTCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841223N611HMPhysical Systems Inc · Carson City, NVBuilt 1976 · S/N 61P-0290-069
Back to AD 87-10-06 R1