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.

N6092VAir Venture LLC · Au Gres, MIBuilt 1980 · S/N 172RG0575N6092WBoling Bret J · Wichita, KSS/N 28-20106N6093Dory Joseph A · Star, IDBuilt 2006 · S/N ED001N60938Thomas Michael F · Glennallen, AKS/N 15070679N6093JAir S & T LLC · San Juan Capo, CAFirst renewal noticeBuilt 1980 · S/N 17273856N6093WLee Richard L · Bowie, TXBuilt 1964 · S/N 28-20107N6094DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1958 · S/N 18-5461N6094FBuiqui Aerospace Corp · Kissimmee, FLBuilt 1979 · S/N 17273147N6094QRakes Bobby N Jr · Saint Robert, MOBuilt 1965 · S/N 3261N6094RBoston Executive Helicopters LLC · Norwood, MABuilt 1979 · S/N M-2209N6096LC&C Airlines LLC · Mesa, AZBuilt 1972 · S/N AA5-0256N6096XBergman James H · Buckley, WAS/N 1694N6097LPetrovich Michael · Simpsonville, SCBuilt 1972 · S/N AA5-0257N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N6097WWallette Robert Michael · Port Saint Lucie, FLBuilt 1964 · S/N 28-20111N6098DShurtleff Russell D · Tunkhannock, PABuilt 1979 · S/N 17272602N6098NRegistered aircraftBuilt 1968 · S/N MB-395N6098WFall Line Aviation LLC · Augusta, GAS/N 28-20112N6099QBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 3263N6099XStar Larry D · Gold Hill, NCBuilt 1960 · S/N 1700AN609DCBarber Aircraft LLC · Topping, VABuilt 1975 · S/N 17265563N609FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716270N60ATOconnor Lloyd T · Dillingham, AKBuilt 1990 · S/N 003N60BEGunn Glenn R · Clearwater, FLBuilt 1992 · S/N 1206N60BZNxbz Aircraft Holdings LLC · Broussard, LAS/N 1171N60CESmith Matthew J · Louisville, KYBuilt 2004 · S/N 22558N60DVDelta Victor LLC · Plano, TXBuilt 2000 · S/N 20053N60GAGlidewell Aviation Inc · Parkland, FLBuilt 1978 · S/N 17271354N60HEagle Flight Squadron Inc · East Orange, NJBuilt 1973 · S/N 17261653N60HFTexas Flying Club Inc · Bryan, TXBuilt 1977 · S/N 17270210N60JKHiner Kirk J · Kenyon, MNBuilt 2004 · S/N 142N60MRHansen Charles R · Covington, TNBuilt 1978 · S/N GA-7-0060N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049N60NCBalsley Matthew · Rowlett, TXS/N 616N60RBShrode Rafe C · Jewett, TXBuilt 1955 · S/N 22-2761N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479N60WEVeillon Joseph B · Alexandria, LABuilt 1974 · S/N 352N60WMSmith Ted J · Lakeland, FLBuilt 2000 · S/N 25041N60WRAmbush One LLC · Memphis, TNBuilt 2003 · S/N 24812N60YGLindstrom Dave C · Marinette, WIBuilt 1974 · S/N 17263953N6100DSzostak Edward M · San Diego, CABuilt 1956 · S/N 22-4744N6100JFranklin County Flying Club Inc · Turners Falls, MABuilt 1976 · S/N 28-7615302N6100PSuarez-Alicea Jorge A · Enterprise, ALBuilt 1959 · S/N 24-1198N6101DHanson John A · Molena, GABuilt 1957 · S/N 22-4745N6101WStuder Joseph D · Troy, KSBuilt 1964 · S/N 28-20115N6102APiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009036N6102DHutchins Chad M · Colorado Springs, COS/N 22-4746N6102PAllen Darren Kerr · Thomasville, GABuilt 1959 · S/N 24-1200N6102RAerospace Aviation Services Inc · Wilmington, DEBuilt 1979 · S/N 172RG0084N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748
Back to AD 79-10-03 R2