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.

N703RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1977 · S/N 28-7716063N703SPFlightline LLC · Lewes, DEBuilt 1985 · S/N 172-76443N703TKLorimar Group Inc · El Cajon, CABuilt 1968 · S/N 28-5165N704Tillery Roger Breck · Cedartown, GABuilt 1957 · S/N 18-6058N7040QOrlandi Properties LLC · Blairstown, NJBuilt 1971 · S/N 17260340N7040RDavies Lori M · Gainesville, TXS/N 28-21737N7040WDemaagd Ross E · Middleville, MIBuilt 1962 · S/N 28-723N7041State Of Alaska · Anchorage, AKBuilt 1961 · S/N 18-7767N70411Charlie Lima 1 LLC · Jacksonville, FLBuilt 1976 · S/N 17267216N70413Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1976 · S/N 17267217N70416Mcgee David · West Monroe, LAS/N 17267218N7041CWayman Christopher Paul · Hyde Park, NYBuilt 1975 · S/N 28-7625067N7041GJohnson Justin Eric · Grand Forks, NDBuilt 1969 · S/N 17258741N7041PMaine Will R · Choctaw, OKBuilt 1960 · S/N 24-2189N7041QElizabeth City State University · Elizabeth City, NCBuilt 1971 · S/N 17260341N7041WRoth Isaac J · Ontario, WIBuilt 1962 · S/N 28-724N7042CBr Flyers Club LLC · Baton Rouge, LABuilt 1975 · S/N 28-7690052N7042G7042g LLC · Shingle Springs, CAS/N 17258742N7042QWatts Ruiz LLC · Waco, TXBuilt 1971 · S/N 17260342N7042UFox Richard L · Gettysburg, PABuilt 1988 · S/N 783N7043BCorral Oscar Luis · Fort Stockton, TXBuilt 1956 · S/N 22-4294N7043CRellinger Michael · Venice, FLBuilt 1975 · S/N 28-7690053N7043QNelson Christopher J · Hayfield, MNBuilt 1971 · S/N 17260343N7043RHolst Thomas C · Pleasant Hope, MOBuilt 1966 · S/N 28-21740N7044BRobison Michael W · York, MES/N 22-4298N7044GSpitzbart David G · Woodstock, ILBuilt 1969 · S/N 17258744N7044RSalzer Vaughn R · Ashley, NDBuilt 1966 · S/N 28-21741N7045BAndresen Victor R · Anchorage, AKBuilt 1956 · S/N 22-4299N7045R509 Aviation LLC · Lewes, DEBuilt 1966 · S/N 28-21742N7045WCooksey Don R · Newcastle, WYBuilt 1962 · S/N 28-800N7045XSale Reported · Colfax, WISale reportedS/N 3236N7046State Of Alaska · Anchorage, AKBuilt 1999 · S/N AK-DPS-01N7046PComanche Aviation LLC · Davie, FLBuilt 1960 · S/N 24-2194N7046RRegistration Pending · Vero Beach, FLRegistration pendingBuilt 1966 · S/N 28-21743N7046WStreed Gwain E Trustee · Christmas Valley, ORBuilt 1962 · S/N 28-802N7047RCoulter Frank R · Cygnet, OHBuilt 1966 · S/N 28-21744N7047WApflight LLC · Naples, FLBuilt 1963 · S/N 28-793N7048DFlowers Bobby J · Parksley, VABuilt 1957 · S/N 22-4945N7048ROdonnell Bernard A · Wilbraham, MABuilt 1966 · S/N 28-21746N7048WHisle Kenneth Ray · Winchester, KYBuilt 1962 · S/N 28-806N7049State Of Alaska · Anchorage, AKBuilt 1968 · S/N 18-8709N70493Starnes Michael A · Murfreesboro, TNBuilt 1976 · S/N 17267220N7049BUnderhill Eugene M · Dufur, ORBuilt 1956 · S/N 22-4303N7049CFlight World Inc · San Juan, PRBuilt 1998 · S/N 2884N7049GLouisville Aircraft Leasing LLC · Louisville, KYS/N 17258749N7049QVortex Aero LLC · Lakeland, FLBuilt 1972 · S/N 17260349N7049WAuto Ink · San Diego, CABuilt 1962 · S/N 28-809N704CZCook David · Tucson, AZBuilt 1977 · S/N 15078518N704FLBabri Masood A · Lorton, VABuilt 1972 · S/N 28-7225256N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750
Back to AD 79-10-03 R2