OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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

N7453DRomo Blaine Jeffrey · Dillingham, AKS/N 22-5219N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N74541Premier Helicopters LLC · Carson City, NVFirst renewal noticeBuilt 2005 · S/N 3865N74542Bauerle Lucas W · Albuquerque, NMBuilt 1961 · S/N 1853N74545Hopkins Tim W · Cincinnati, OHBuilt 1961 · S/N 1911N74547Travierso Alan S · Farmington, UTBuilt 1961 · S/N 1913N74549Woodyard Tory · Mcloud, OKBuilt 1961 · S/N 1914N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N7454PCreation Industries LLC · Middlefield, OHBuilt 1961 · S/N 24-2644N7454WPorter Robert D · Manchester, TNBuilt 1963 · S/N 28-1343N74553Young John H · Sheridan, WYBuilt 1961 · S/N 1945N74555Pieszala John W · Larksville, PABuilt 1961 · S/N 1947N74556Gutierrez Juan · Sarasota, FLBuilt 1961 · S/N 1948N74557N74557 LLC · Kissimmee, FLBuilt 2005 · S/N 3900N7455DD'Amico Joseph J · Mount Ary, MDBuilt 1957 · S/N 22-5221N7455PEagles Aviation LLC · Rocklin, CABuilt 1961 · S/N 24-2645N7455RMcanelly Anthony J · Maricopa, AZBuilt 1966 · S/N 28-22000N7455SSharp Penny E · Ocala, FLBuilt 1991 · S/N 10043N7455WNicolai Tim A · Brandon, SDBuilt 1963 · S/N 28-1365N74560Willett Lynn B · Wooster, OHBuilt 1976 · S/N AA5B-0251N74561George James H · Punta Gorda, FLBuilt 1976 · S/N AA5B-0252N74562Hamm Donald S · Carrollton, TXFirst renewal noticeS/N 1873N74564November Alpha LLC · Dover, DEBuilt 2005 · S/N 3908N74565Shai Evan · Oak Bluffs, MABuilt 1961 · S/N 1876N74566Kerns Stanley M · Berryville, VABuilt 1961 · S/N 1877N74568Willis Charles D · Katy, TXBuilt 1961 · S/N 1879N74571Mccurry Richard H · El Dorado, CABuilt 1961 · S/N 1882N74573Strout Adam Geoffrey · Manchester, MABuilt 1961 · S/N 1884N74574Burrell Helicopters LLC · D Hanis, TXBuilt 2005 · S/N 3913N74576Varnes Mark R · Westminster, CAS/N 1887N74579Bethell A Ray · Heavener, OKFirst renewal noticeBuilt 1961 · S/N 1890N7457LPiper Lover LLC · Centennial, COBuilt 1975 · S/N 18-7509051N7457RFoster Adam W · Midland, TXBuilt 1966 · S/N 28-22002N7457WNilsson Tim E · Yreka, CABuilt 1963 · S/N 28-1346N74581Lane Tyler R · Berthoud, COS/N 1892N74582Moo Nee LLC · Vero Beach, FLBuilt 1962 · S/N 1893N74583Mile High Carpet Rides LLC · Dover, DEBuilt 2005 · S/N 3923N74586Rainwater Farms LLC · Dover, DES/N 1897N74587Curtis David W · Watertown, NYBuilt 1961 · S/N 1898N7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1347N74590Registration Pending · Barry, TXRegistration pendingBuilt 1976 · S/N AA5B-0253N74591Tiger Aero LLC · Beresford, SDBuilt 1976 · S/N AA5B-0254N74592Higgs III Cyrus H · Jackson, TNBuilt 1976 · S/N AA5B-0255N74593Sandlin Jesse L · Chesterfield, VABuilt 1976 · S/N AA5B-0257N74594Pinger Kevin R · Palo Alto, CAS/N AA5B-0260N74595Ehrhard Robert A · Jasper, INBuilt 1976 · S/N AA5B-0263N74596Cato James W · Las Cruces, NMS/N AA5B-0264N74597Airman Helicopter Inc · Fort Lauderdale, FLBuilt 2005 · S/N 3927N74599Fletchair Inc · Comfort, TXBuilt 1976 · S/N AA5B-0267N7459LStewart Martin J · Anchorage, AKBuilt 1975 · S/N 18-7509054
Back to AD 79-10-03 R2