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.

N6628PRavich Vladimir · Fort Montgomery, NYBuilt 1960 · S/N 24-1751N6628RD & K Aero · Elkhart, INBuilt 1974 · S/N M-1607N6628WFigueroa Ruben E · Las Vegas, NVBuilt 1965 · S/N 28-20725N6629FCloud10 Aviators LLC · Benton, LABuilt 1976 · S/N 32-7700003N6629PCrouse William F · Priest River, IDBuilt 1960 · S/N 24-1752N6629RDempsey Yvonne Grace · Guys Mills, PABuilt 1975 · S/N M-1609N6629UHanggee Sanford C · Aurora, COBuilt 1963 · S/N 124N6629WWilcox Chris M · Canajoharie, NYBuilt 1965 · S/N 28-20726N662APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843774N662BFFoster Robert B · Erie, PABuilt 1997 · S/N RBF01N662CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 318052014N662EZRegistered aircraftBuilt 2024 · S/N 41928N662FLane Bruce · Midlothian, VABuilt 2024 · S/N 41907N662GSouthwest Property Exchange LLC · Cedar City, UTBuilt 2007 · S/N 40705N662KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 18-8209023N662NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881149N662RKlotz Douglas · Incline Village, NVBuilt 1960 · S/N 39102N662RFJdm Aero LLC · Pearland, TXBuilt 2006 · S/N 40374N662RSBender Jeff L · Canal Winchester, OHBuilt 2005 · S/N 0222N662SPCessna N662sp LLC · Duluth, GABuilt 1998 · S/N 172S8066N662TSchoch Michael Pa · Punta Gorda, FLBuilt 1958 · S/N TD-70N662TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881962N662TMUpright Corp · Kentfield, CABuilt 2004 · S/N T18208247N662WPHolt Gary L · Ventura, CABuilt 2000 · S/N 4636308N6630AIndigo Associates Ltd · Las Vegas, NVBuilt 1978 · S/N 27-7954027N6630PSumners Toby · Aurora, MOBuilt 1960 · S/N 24-1753N6630RGamma2 Inc · San Diego, CABuilt 1974 · S/N MC-314N6630UBartholow Paul V · Santa Rosa, CABuilt 1963 · S/N 125N6630WRiggin Flight Service Inc · Madison, SDS/N 28-20728N66313Brazon Brian D · Belle Vernon, PABuilt 1980 · S/N M-2192N6631FYah Inc · Wilmington, DEBuilt 1976 · S/N 32R-7780033N6631UMitchell Caleb C · Hebron, NEBuilt 1963 · S/N 126N6631WRegistration Pending · Arbela, MORegistration pendingBuilt 1965 · S/N 28-20729N6631ZClark Ryan D · Sequim, WAS/N M-2190N6632GGrayson Robert E · Great Falls, MTBuilt 2016 · S/N 109N6632JSo Cal Leasing LLC · El Cajon, CABuilt 1980 · S/N ME-337N6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N M-2188N6632ZFranconia Soaring Association · Franconia, NHBuilt 1963 · S/N 25-2216N66337Bales Robert · Osage Beach, MOBuilt 1979 · S/N M-2201N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239N6633FRegistration Pending · Moses Lake, WARegistration pendingBuilt 1979 · S/N M-2196N6633JBailey Randall D · Oakley, MIS/N 28-5099N6633PSkinner Norman D · Osceola, IABuilt 1959 · S/N 24-1756N6633RBlake Anthony B · Hallsville, TXBuilt 1979 · S/N M-2198N6633WSyf LLC · Okmulgee, OKBuilt 1965 · S/N 28-20731N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241N66344Sallee Philip L · Yucca Valley, CABuilt 1979 · S/N M-2207N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234N6634JMaier Robert B · Duncanville, TXBuilt 1968 · S/N 28-5101N6634UC A F E Aviation LLC · Gregory, SDBuilt 1963 · S/N 129
Back to AD 87-10-06 R1