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.

N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504N7204WKlein Kaylin · Stillwater, OKBuilt 1963 · S/N 28-1017N7204ZKettley Rick W · Steward, ILBuilt 1964 · S/N 25-3115N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905N7205PL F Rothschild & Company Inc · Shingle Springs, CANon-citizen corporation, flight hours not reportedS/N 24-2375N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505N7206CDwyer Benjamin J · Colorado Springs, COBuilt 1976 · S/N 28-7625072N7206FVoyage Capital Ventures LLC · Knightdale, NCBuilt 1968 · S/N 28-25114N7206LWilliams Harry D III · Summerland Key, FLS/N 22-5030N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506N7206WSchimmel O L · Port Hueneme, CABuilt 1963 · S/N 28-1020N7206YSkyflite LLC · Hillsboro, ORS/N 30-232N7207Board Of Trustees · Battle Creek, MIBuilt 1962 · S/N 18-7859N7207BThomas Conners · Melbourne Beach, FLBuilt 1999 · S/N 18280558N7207DHerrick David L · Mont Vernon, NHBuilt 1957 · S/N 22-5031N7207FLandmark Title Inc · Clovis, NMBuilt 1968 · S/N 28-25115N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907N7207JErhardt Industries LLC · Ottumwa, IABuilt 1968 · S/N 28-24540N7207PSteinbach Philipp · Bentonville, ARBuilt 1960 · S/N 24-2377N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507N7207WValkaria Flyers LLC · Palm Bay, FLBuilt 1963 · S/N 28-1021N7208DCopper River Airmotive LLC · Copper Center, AKBuilt 1957 · S/N 22-5032N7208FWignot Andrew R · Oceanside, CABuilt 1968 · S/N 28-25117N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908N7208JWelby Samantha · Eastampton, NJBuilt 1968 · S/N 28-24541N7208WSky View Aviation LLC · Porter, OKS/N 28-1117N7209DBlue Weayne E · Rochester, NYBuilt 1957 · S/N 22-5033N7209FNew Garden Township · Landenberg, PABuilt 1968 · S/N 28-25118N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235N720ACKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1270-99N720BHPetersen Bennett C · Medina, OHBuilt 1994 · S/N 053N720CBLee Douglas A · Quincy, CABuilt 1992 · S/N 7-0490N720FLExecutive Flight Training & Services LLC · Sanford, NCBuilt 1972 · S/N 28-7225401N720GCCox Gary E · Davis, CABuilt 1972 · S/N 28R-7235317N720GPCharlie Hotel Corp · Wilmington, DEBuilt 1977 · S/N 28-7790366N720JBSchoettle Steve P · Heber Springs, ARBuilt 1979 · S/N 32-7940150N720JHTuysserkani Bijan · Boulder, COBuilt 2016 · S/N 41485N720JPThomas Ryan J · Bend, ORBuilt 2009 · S/N 72162N720KMTrubee Jay G Trustee · Palm Desert, CABuilt 2002 · S/N 3257300N720LSBellotte Travis J · Morgantown, WVBuilt 2005 · S/N DMO-383N720MGRegistered aircraftS/N 11302N720NWNunez Frank · Orlando, FLBuilt 1978 · S/N M-2079N720PAValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 2843386N720RKLong Philip Charles · Ojai, CAS/N 18280055N720SHBrooke James B · Salisbury, MDBuilt 1997 · S/N 3246085N720SPFlying L Aircraft Inc · Fort Denaud, FLBuilt 1997 · S/N 301
Back to AD 87-10-06 R1