OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N90462Manning Mark D · Wrenshall, MNBuilt 1959 · S/N 325N9046QDavis John A · Eau Claire, WIS/N 28-7125089N9047DHansen Bailey · Juneau, AKBuilt 1958 · S/N 22-6186N9047JHalajian Dominic M · Rogers, MNBuilt 1966 · S/N 28-3078N9047LDaniel Bryan G · Childress, TXS/N 217-70N9047YWeiss Michael F · Wyckoff, NJBuilt 1970 · S/N 18-8907N9048HGravesen Mark A · Kenmare, NDBuilt 1975 · S/N 17265917N904CCAlex Theodore P · Washington Depot, CTBuilt 1999 · S/N 9904CCN904DCGriswold Ryan M · Vista, CABuilt 2004 · S/N 90107N904KJKlima Kenneth N · Greendale, WIBuilt 2010 · S/N 91201N904PWJax Beach Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 17257275N904RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 17267060N904UAlaskas Untamed Adventures LLC · Soldotna, AKBuilt 1974 · S/N 18-7409123N904XCHarmon Philip E · Clifton, TXBuilt 2009 · S/N 84096N9050JHunt-Thorton Trevon · Aurora, COBuilt 1966 · S/N 28-3081N9051BFinished Work Aviation LLC · Redding, CAS/N 7FC-139N9051FMccambridge Michael · Pacific Grove, CAS/N 18-2519N9052JLairmore John H · Owasso, OKBuilt 1966 · S/N 28-3083N9052LOlson Ronnie E · Palmer, AKBuilt 1970 · S/N 271-70N9053JThompson Scott C · Redwood City, CABuilt 1966 · S/N 28-3084N9053MMclellan James W · Phoenix, AZBuilt 2008 · S/N 11381N9053USmart Tim · Spurger, TXBuilt 1987 · S/N 0658N9054DWalsh Peter F · Hillsborough, NCBuilt 1982 · S/N 100N90558Hagele Aviation LLC · Hillsboro, ORS/N 17274773N9056YThompson Dennis E · Anchorage, AKBuilt 1980 · S/N 0001N9057HAmoroso Ricardo C · Powder Springs, GABuilt 1975 · S/N 17265921N9057JBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1966 · S/N 28-3091N9058DBallard David L Trustee · Chugiak, AKBuilt 1958 · S/N 22-6198N9058JRubinic Brandon S · Harrisburg, PABuilt 1966 · S/N 28-3092N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70N9059DGladstone Stephen · Mesa, AZS/N 20570N9059QStevens Donald F · Canton, GAFirst renewal noticeBuilt 1981 · S/N 0143N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651N905DWDue South LLC · Wilmington, DEBuilt 2006 · S/N 22780N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9060JGillis Joseph V · Tempe, AZBuilt 1966 · S/N 28-3094N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70N9061DRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-6426N9062JVernon Sharnell Tamieko · Phoenix, AZS/N 28-3096N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70N9063DHanson Lavon T · Saint Ignatius, MTBuilt 1958 · S/N 18-6428N9063JHardison Samuel H · Mountain View, ARS/N 28-3097N9064JSolomon Michael Lee · Hope Mills, NCBuilt 1966 · S/N 28-3099N90669Cape Copters LLC · Scott City, MOBuilt 1981 · S/N 0119N9067DWing Robert E · Fairbanks, AKS/N 18-6432N9067JEvans Jennifer M · Escalante, UTS/N 28-3102N90687Robinson Jere L · Burnet, TXBuilt 1968 · S/N 18-8734
Back to AD 79-10-03 R2