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.

N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272N7311DRasmussen Kent L · Jetmore, KSBuilt 1957 · S/N 22-5099N7311FRegistered aircraftBuilt 1968 · S/N 28-25225N7311JBouley John T · Tolland, CTFirst renewal noticeBuilt 1968 · S/N 28-24658N7311SDayton Pilots Club Inc · Germantown, OHBuilt 1981 · S/N R18201703N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354N7311ZBermuda High Soaring School · Lancaster, SCBuilt 1965 · S/N 25-3258N7312DJenkins James L · Lake Stevens, WABuilt 1957 · S/N 22-5100N7312WRegistered aircraftBuilt 1977 · S/N R18200053N7312XFellows Thomas C · Prescott, AZBuilt 1977 · S/N R18200071N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356N7313ZSimmons Mark A DBA · Pawcatuck, CTBuilt 1965 · S/N 25-3245N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290N7314FAero Vantage Aviation Services LLC · Bayonne, NJBuilt 1968 · S/N 28-25272N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014N7314WWelch Tully D · Brackettville, TXBuilt 1963 · S/N 28-1177N7315Frattasio Damian E · Pembroke, MABuilt 1989 · S/N T/Q 001N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293N7315DSkyhaven Airport Inc · Tunkhannock, PABuilt 1957 · S/N 22-5103N7316GCox Capital LLC · Rushville, MOS/N 17259016N7316PCase Mark A Trustee · Shady Shores, TXBuilt 1961 · S/N 24-2492N7316WCallaboo LLC · Greenwood, SCBuilt 1963 · S/N 28-1180N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299N73174Welch Cleatus E · Orlando, FLBuilt 1976 · S/N 17267301N7317FMiller Steven G · Kent, WABuilt 1968 · S/N 28-25227N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017N7317JBengtson Timothy R · Boulder Creek, CABuilt 1968 · S/N 28-24666N7317KDawson Brian E · Tucson, AZS/N 2184N7317XMoore Samuel B · Tucson, AZS/N R18200073N7317YComanche Air Services LLC · Westminster, COBuilt 1964 · S/N 30-360N73181Nurse Alex S · San Diego, CABuilt 1976 · S/N 17267308N73183Sandwich Aviation Inc · Somonauk, ILBuilt 1976 · S/N 17267310N73189Ellie Air LLC · Mabank, TXBuilt 1976 · S/N 17267316N7318DAir & Field Equipment LLC · Moore, IDS/N 22-5106N7318FTwo Weeks LLC · East Palo Alto, CABuilt 1968 · S/N 28-25228N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018N7318JHdr Aero LLC · Lewes, DEBuilt 1968 · S/N 28-24667N7318YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 30-361
Back to AD 87-10-06 R1