OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150N127826350 LLC · Yorklyn, DES/N 17702387N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261N1278JBallester Alexis R · Mayaguez, PRBuilt 1975 · S/N 278N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267N1279XRegistered aircraftBuilt 1963 · S/N 152N127AKSwan Logistics LLC · Toledo, OHS/N 2059N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127CGRegistered aircraftBuilt 2025 · S/N 41976N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023N127EYoung John C · Olathe, KSBuilt 2001 · S/N 2146N127EMKrein Chris · Bismarck, NDS/N 121707N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481N127FRYoon Paul · Saint David, AZS/N 17275292N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343N127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248N127LFFisher Nicholis W · Springfield, LAS/N 27N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503N127PMinard Robert Myron Jr Trustee · Laveen, AZBuilt 1997 · S/N 24672N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010N127RBushby Harvey M Jr · Minonka, ILBuilt 1995 · S/N M-II-1110N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108N127VATelkamp Gary O · Rapid City, SDBuilt 2003 · S/N 90127N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274N127WMMagnum Consulting Group Inc · Scottsdale, AZBuilt 1993 · S/N 1369N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253N1280XErlandson Michael D · Salt Lake City, UTS/N 153N12819Stewart Todd L · Mooresville, NCS/N 17262288N1281KKirkwood Billie R · El Paso, TXBuilt 2011 · S/N 24143N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291
Back to AD 87-10-06 R1