OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N33GRHeadrick John Eric · Eolia, MOS/N 259-76N33GVMilhous Richard J · Aguila, AZBuilt 2017 · S/N PETERSON 3N33HParker Shon T · San Angelo, TXBuilt 1968 · S/N 28-11115N33HRHarpole Mark J · Sisters, ORBuilt 2000 · S/N 004N33HSN33hs LLC · Tallahassee, FLS/N 1HSN33HURunzel Brothers Aviation LLC · Bensenville, ILS/N 1310N33JSaunders Dwayne E · Cary, NCBuilt 1973 · S/N JF-1N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144N33JDRiggs Alan Vance · Artesia, NMBuilt 1979 · S/N 32-7940159N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061N33JKMidway Aviation Co · Plant City, FLBuilt 1977 · S/N 7-0132N33JMKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 28-10305N33JXProuty Timothy V Trustee · North Providence, RIBuilt 1977 · S/N AA5B0585N33KMathison John Michael · Fernley, NVBuilt 1977 · S/N 828N33KJPlane Fun Inc · Bow, WABuilt 1998 · S/N 23035N33KWWoods Erik K · Byers, COBuilt 2019 · S/N 40177N33LHKeller Charles T · Thaxton, MSBuilt 1968 · S/N 28-11098N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N33LYBobo Robert A · Pullman, WABuilt 2001 · S/N 001N33PGFoundation Of Wayne Community College Inc · Goldsboro, NCS/N 1782-5N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33PLMcgraw Dennis S · Oakland, TNBuilt 2005 · S/N 60526N33PRWings To Carolina LLC · State College, PABuilt 1976 · S/N 32R-7780087N33PSN33ps LLC · Shoemakersville, PABuilt 1978 · S/N 32R-7885277N33PZRygiel Jerome A · Saint Cloud, FLBuilt 1975 · S/N 28-7615040N33RBJudy Charles E · Lawrenceville, ILBuilt 1999 · S/N 195699N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SMoose Aviation LLC · Henderson, KYBuilt 1995 · S/N K066N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370N33SPCray Jaeger · Hilton Head, SCS/N 28-366N33SSRegistration Pending · Palmdale, CARegistration pendingBuilt 1966 · S/N 30-1104N33SXGonzalez Richard J · Granbury, TXFirst renewal noticeS/N JONAS-0006N33SYFlight Level 510 LLC · El Dorado Hills, CABuilt 2004 · S/N 40.370N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043N33UPAero Valley Properties LLC · Roanoke, TXBuilt 1961 · S/N 320-0078N33VLPalmer Thomas W · Boulder City, NVBuilt 1994 · S/N 11043N33WKilcourse Jeffrey K · Tequesta, FLBuilt 1990 · S/N 233N33WAThompson Casey · Edmond, OKBuilt 1975 · S/N M-1619N33WBSycamore Aviation Services LLC · Terre Haute, INBuilt 1978 · S/N 32R-7987056N33WJKite Air LLC · Staten Island, NYBuilt 1977 · S/N 32R-7780443N33XXPtacek Stephen R · Estes Park, COBuilt 1938 · S/N 14N33YBBriggs Kent · Manhattan, KSBuilt 1963 · S/N 28-956N33YYMoore Keith V · Germantown, TNBuilt 1966 · S/N 28-3230N33YZJenkins Blake T · Lakeland, FLBuilt 1978 · S/N 24-0631N33ZCMarker Michael M Jr · Los Lunas, NMBuilt 1987 · S/N 3N33ZDBentley Jeffrey W · Kenmore, WABuilt 2009 · S/N 71555N33ZMUrban Timothy J · Laytonsville, MDBuilt 1966 · S/N 30-1044N34005Hinckley David D · Belton, TXFirst renewal noticeBuilt 1970 · S/N 17701590
Back to AD 87-10-06 R1