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.

N2467CKsg Capital LLC · Casper, WYBuilt 2000 · S/N 18280789N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294N2468FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 18280780N2468HStallings Cameron G · Clovis, NMBuilt 1979 · S/N 18-7909191N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391N2468MSmith Steven Paul · Dammeron Valley, UTBuilt 2024 · S/N 8389N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074N2468WGodwin Gerald · Orange, TXS/N 886-2001N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N246AJJensen Alan · Rock Springs, WYBuilt 2013 · S/N 82207N246AKGordon Andrew J · Paulding, OHBuilt 1999 · S/N 778N246AWSullivan Stanley D · South Jordan, UTS/N 72610N246AZRegistered aircraftBuilt 1983 · S/N 28-8311025N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485N246DAAdams Dennis M · Idaho Falls, IDBuilt 2021 · S/N 92131N246DTElswick Theodore · Fernley, NVS/N 71828N246FC69px LLC · Suttons Bay, MIBuilt 2023 · S/N 246N246HNStamos Michael A · Buchanan Dam, TXBuilt 1986 · S/N 246N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003N246JDHilliard Bruce · Grantsville, UTS/N 74-31105N246JKTobin Thomas · Sparks, NVBuilt 2000 · S/N 99197N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535N246JSSullivan Jason W · North Pole, AKS/N 60201N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91N246MEWyoming Seaplanes LLC · Alpine, WYBuilt 2000 · S/N T20608194N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N246NSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608246N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PKGeneva1 Aviation LLC · Mars, PABuilt 1995 · S/N 20008N246PMBesprozvanny Randy-Alexander R · San Marcos, CABuilt 1977 · S/N AA5B-0566N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005N246RKFreeborn Mark Trustee · Phoenix, ORS/N 22861N246RLSwiss Eagles Inc · Las Vegas, NVBuilt 1984 · S/N L-0026N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023N246SRFriendship Church · Frisco, TXBuilt 2006 · S/N 042SRN246SVN246sv Corp Trustee · Wilmington, DEBuilt 2001 · S/N 25068CN246TFMorgan Daniel D · Topeka, KSS/N R18201677N246TMTango Mike Aviation LLC · Seneca Falls, NYS/N 3238N246TTTerry Timothy D · Gainesville, TXS/N 70518N246VABrascher Harry M · Spotsylvania, VABuilt 2003 · S/N 81121N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427N247Bonewitz John A · Grapevine, TXBuilt 1999 · S/N 23846N2470FMeridian Aviation LLC · Lincolnton, NCBuilt 2000 · S/N 18280890N2470HKing Bruce J · Waldport, ORBuilt 1979 · S/N 18-7909192
Back to AD 87-10-06 R1