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.

N210SVBevis Richard L · Middletown, OHBuilt 1978 · S/N 17271361N210SXSims Stephen E · Locust Grove, GABuilt 1946 · S/N 394N21116Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7916025N2111FDhs Operations LLC · Wilmington, DEBuilt 1978 · S/N 44-7995153N2111ZNunn Henry · Noble, OKBuilt 1973 · S/N 28-7305515N21123Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916027N21124Mitchell Andrew D Trustee · Winnie, TXBuilt 1974 · S/N 17263894N21126Aviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263895N2112FBank Of Utah Trustee · Salt Lake City, UTS/N 44-7995154N2112KRocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1978 · S/N 28-7990234N2112NV & R Aviation LLC · Georgetown, TXBuilt 1979 · S/N 28-7990276N2112PHardin John M · Terrell, TXBuilt 1956 · S/N 23-703N2112ZWilson Mickey Ray · Skagway, AKBuilt 1979 · S/N 28-7990394N21131Emge Douglas W · Albertville, ALBuilt 1978 · S/N 28-7990035N2113ASale Reported · Glasgow, MTSale reportedS/N 18-1844N2113JAlternate Air Inc · Seattle, WABuilt 1975 · S/N 17264982N2113KCalvin B Wiley · Summer Shade, KYS/N TD-283N2113WMarschke Corey A · Stevens Point, WIBuilt 1973 · S/N M-1441N2114CLegacy By Design LLC · Durham, CAS/N 2114N2114FChapel Hill Flying Club DBA · Sanford, NCBuilt 1978 · S/N 28-7916169N2114JMonaco Joseph · Castleton, VTBuilt 1978 · S/N 28-7916224N2114KRcs Services LLC · California, MDBuilt 1978 · S/N 28-7990235N2114PRiggin Flight Service Inc · Madison, SDS/N 23-705N2114WHippensteel Michael J · Newville, PABuilt 1973 · S/N M1449N2114XGsi Corp · Eastham, MABuilt 1970 · S/N 17259495N21157Beta Fleet LLC · South Burlington, VTBuilt 1974 · S/N 17263901N21159Kope Gregory A · Leesburg, VABuilt 1974 · S/N 17263902N2115JMartin Aviation LLC · Bargersville, INBuilt 1978 · S/N 28-7916196N2115MRedman Company LLC · Troy, MIBuilt 1972 · S/N 177-01703N2115UDengler Steven G · Lopez Island, WAS/N 163N21167Tidewater Aviation LLC · Easton, MDBuilt 1978 · S/N 28-7916028N2116FVarani Hugo Leonardo Cordova · Houston, TXBuilt 1978 · S/N 28-7916171N2116JWard John C · Novato, CABuilt 1978 · S/N 28-7916197N2116UBreaux Family Investments LLC · Alexander City, ALS/N 28-7990329N2117EWright Christopher Andrew · Lynn, MABuilt 1978 · S/N 28-7916163N2117KTemptation Motors Ltd · Hayward, CABuilt 1947 · S/N 4844N2118WWegner John B · Preston, MDBuilt 1973 · S/N M-1491N2118YS&G Enterprise Inc · Owensville, INBuilt 1962 · S/N 17249618N21199Shaw Deane F · Centerville, MABuilt 1974 · S/N 17263905N211AVN8191e LLC · Manassas, VABuilt 1979 · S/N 17272151N211BAWojteczko Jason A · Derby, KSBuilt 1977 · S/N 17270071N211BSMustang II Inc · Madison Heights, MIS/N M-II-1241N211DMBuell Travis · Harper, TXS/N 0542N211DXHalter Dudley M · Locust Grove, GAS/N 17265119N211GCN211gc LLC · Jacksonville, FLBuilt 1996 · S/N 21194N211HPN211hp LLC · Lantana, FLBuilt 1980 · S/N 17274152N211JDMeter Alan Van · Wichita, KSBuilt 1979 · S/N 001-J-D-BN211JJKimber Michael L · Grantsville, UTBuilt 2011 · S/N 2011N211JKNelson Christopher B · Fort Atkinson, WIBuilt 1972 · S/N AA5-0049N211KSEaton Gerald M · Fishers, INBuilt 1994 · S/N 20322
Back to AD 79-10-03 R2