OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N24057Macaluso Raymond A · Sweetwater, TNBuilt 1977 · S/N M-1937N2405HPrevatt Stephen W DBA · Kodiak, AKBuilt 1979 · S/N 18-7909181N2405JHorne Donald Bayne Jr · Corpus Christi, TXS/N 18-7909118N2406JPorter Wade R · Durham, CABuilt 1979 · S/N 18-7909119N2406XBrumit John E Jr · Odessa, TXBuilt 2003 · S/N 01N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757N240MFMillis Ronald · Williamsburg, VABuilt 2002 · S/N 0024N240MKFly254 LLC · Waco, TXS/N 28-26527N240RDOrourke Donald A · Tucson, AZBuilt 2001 · S/N 5045N240SBPeacock Bradley B · Norco, CABuilt 2000 · S/N 01N240SMDance Bruce B · Carthage, MOBuilt 1985 · S/N 1-185N240SSStroup Robert L · New River, AZS/N 345-80N240WWelsh David G · Payson, AZBuilt 1987 · S/N 24N2410EKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17271272N2410PPerry William N · Anchorage, AKBuilt 1955 · S/N 18-4277N2411FAarow Aircraft Leasing LLC · Mcminnville, ORS/N 0549N2412RGagnon David D · New Market, ALS/N 28-5615N2413Gabardi Duane A · Manitou Springs, COBuilt 1963 · S/N 2624N2413TRing Michael E · Lake Village, INBuilt 1971 · S/N 28-7205053N2414PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4289N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417KDarley Vernon O · Peachtree City, GABuilt 2024 · S/N HC 0186N2417PMehling Craig · Hardin, MTS/N 18-4293N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614N241BDHanus David S · Mound, MNS/N 60477N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241DWGaither William W Jr · Shallotte, NCS/N 634RGN241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889N241GWWheeler Gregory R · Spicewood, TXS/N 2248N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241KDReiter Kenneth L · Plano, TXBuilt 1998 · S/N 162N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602N241LWDrouin William · Brookline, NHBuilt 1970 · S/N 700088N241MJMj Aero LLC · Mims, FLBuilt 1987 · S/N 1055N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051N241PCPlucinski David J · San Clemente, CABuilt 2005 · S/N 1385-2005N241PLAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 17276422N241RAGreat Escape Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 1322-2001N241TTTherrell G Tony · Kannapolis, NCBuilt 1979 · S/N AA5B1113N241VUDynamic Aircraft Services LLC · Hurst, TXS/N 28-7515409N241WHMiller Michael A · Huffman, TXBuilt 1951 · S/N 18-816N2420QBobby J Kirby Jr LLC · Hernando, FLBuilt 2004 · S/N 2894N2421PBoyko Matthew · Gilbert, AZBuilt 1955 · S/N 22-2792
Back to AD 79-10-03 R2