AD 75-16-10

Registered aircraft · 2,695

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:75-16-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10')
  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.

N142MCCassen Mark E · Wilson, WYBuilt 1973 · S/N TC-1579N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841N1440R39a LLC · Sioux Falls, SDBuilt 1966 · S/N TE-175N1449GFayettenam Aero LLC · Laurinburg, NCS/N TC-248N144RCKilgore Shawn K · Argyle, TXBuilt 1974 · S/N TC-1750N1451GCox Keith L · Griffin, GABuilt 1962 · S/N TC-249N145DDemaray Russell N · Sedona, AZBuilt 1980 · S/N TC-2348N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N147GGZeng Robert E · Owasso, OKBuilt 1962 · S/N TC-260N148DSEast Ramp Aviation LLC · Baton Rouge, LABuilt 1986 · S/N TH-1439N14AJChalk 2 Inc · Apple Valley, CABuilt 1980 · S/N TH-1154N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14DADonaire Aviation LLC · Tampa, FLBuilt 1962 · S/N TD-505N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14XMMedical Diagnostic Imaging Inc · Sacramento, CABuilt 1976 · S/N TH-758N1500LLandolt Gregg E · Moreno Valley, CABuilt 1968 · S/N TC-1120N1509ZHeinrich John W · Chandler, AZBuilt 1961 · S/N TC-210N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218N151FClark Robert G · Healdsburg, CABuilt 1964 · S/N TC-613N1524ZColumbus Baron Partners Llp · Columbus, GABuilt 1961 · S/N TC-218N1526MGarmin At Inc · Salem, ORBuilt 1994 · S/N TH-1711N1526WSmith Neil Walter · Rincon, GABuilt 1972 · S/N TE-857N1529SRich Aviation Services LLC · Fort Worth, TXBuilt 1963 · S/N TC-528N152BGBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1976 · S/N TC-2015N1531ZShenandoah Whalen · Amelia, OHBuilt 1961 · S/N TC-205N1545WM T Air LLC · Olive Branch, MSBuilt 1989 · S/N TH-1545N1545ZMcpherson Russell H · Forest Lake, MNS/N TC-213N154QBrandon Sidney Jordan III · Dundas, VABuilt 1964 · S/N TC-798N1552WT3 Aerosports LLC · Vian, OKBuilt 1972 · S/N TC-1444N1557W557 Whiskey LLC · Superior, WIBuilt 1972 · S/N TH-229N155AGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N TC2311N155FRSpeed Aviation Holdings LLC · Lewes, DEBuilt 1970 · S/N TE-817N155JAStavrides Paul · Hartsville, PABuilt 1976 · S/N TC-1993N155JB2mec Holdings LLC · Kalispell, MTBuilt 1966 · S/N TC-1025N155LUnderwood Robert · Waxahachie, TXBuilt 1968 · S/N TE-467N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615N155STAzimi Shahram · Hayward, CABuilt 1964 · S/N TC-651N155WCTca Equities LLC · Advance, NCBuilt 1981 · S/N TE-1193N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717N1561WEmpresas Marex Inc · Mayaguez, PRS/N TC-1445N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1564SRegistered aircraftBuilt 1962 · S/N TC-313N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566W66 Whiskey LLC · Atlanta, GABuilt 1994 · S/N TH-1713N1567AKarsten Steven R · San Juan Capo, CABuilt 1969 · S/N TC-1270N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542
Back to AD 75-16-10