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.

N4283SHayes Timothy · Gray, MEBuilt 1974 · S/N 17263748N4283TDziak Chester · Jackson, MIBuilt 1971 · S/N 28-7225120N4283ZHuseby Kelly E · Hulett, WYBuilt 1967 · S/N 18-8530N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088N4284ZBolin Matthew R · Everett, WABuilt 1967 · S/N 18-8532N4285HPralle Jeffory K · Wasilla, AKBuilt 1948 · S/N 14-90N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185N4285TBuenger Michael · Gilbert, AZBuilt 1971 · S/N 28-7205056N4285ZYoseph Barry L · Olympia, WABuilt 1967 · S/N 18-8534N42867Burns Charles R · Huntsville, ALBuilt 1974 · S/N 28-7425319N4286PGress Gabrielle M · Davenport, FLBuilt 1959 · S/N 23-1786N4286ZMalcolm Rodgers K Jr · Belzoni, MSS/N 18-8599N4287JBillingsley Steven M · Prosperity, SCBuilt 1967 · S/N 28-22651N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187N42885Sisca John A · Gilbert, AZBuilt 1974 · S/N 28-7415403N4288HHoogendorn Homer E · Wasilla, AKBuilt 1948 · S/N 14-78N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188N4288ZAltobelli Matthew J · Dover, PABuilt 1967 · S/N 18-8601N4289JMiller Curtis L · Brownstown, PABuilt 1967 · S/N 28-22654N4289THohm Harold C · Chicago, ILBuilt 1971 · S/N 28-7205133N428ACMckinley Nathan C · New Braunfels, TXBuilt 2000 · S/N 1288-2000N428DMCochran Michael S · Centennial, COBuilt 1995 · S/N 428N428JSHoerr Stacy D · Taylor, MOBuilt 1993 · S/N 101N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476N428RHegy Thomas R · Hartford, WIBuilt 1971 · S/N 244-HN428RBHouser Blue D · Edgemoor, SCBuilt 1963 · S/N 128N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092N428SXMann John Franklin Jr · Marietta, GABuilt 2014 · S/N 001N428WJGossett Corey G · Victoria, TXS/N F8L100N4290HOwen Toy C · Anchorage, AKS/N 14-94N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539N42917Afmr Inc · Dover, DEBuilt 1991 · S/N 2691N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196
Back to AD 79-10-03 R2