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.

N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944N886RVBazazan Mehrdad D · Fredericksburg, VABuilt 1994 · S/N 21707N886SACumbass David Shane · Douglas, GABuilt 2000 · S/N 0004N8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044N8870JAsel LLC · North Charleston, SCS/N 28-2842N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872JPriority Aviation LLC · Lewes, DES/N 28-2844N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852N8879NBesheer Susan Anita · Palm Springs, CABuilt 1969 · S/N 28-25743N8879YWelstad Blaine L · Newburg, NDBuilt 1973 · S/N 18-7409027N887BCAustin Aviation LLC · Boise, IDBuilt 2023 · S/N 627-2023N887CCMr Dent Inc · Manheim, PABuilt 1978 · S/N GA7-0044N8880NAnderson Aviation LLC · Bulverde, TXS/N 28-25744N8881VLien Ronald N · Gilford, NHS/N 17264240N8882FCirrus Services Inc · Fargo, NDBuilt 1976 · S/N 28-7715294N8882VTop Aircraft Leasing LLC · Wilmington, DEBuilt 1974 · S/N 17264241N8883JRegistration Pending · Midlothian, TXRegistration pendingBuilt 1965 · S/N 28-2857N8883NWarner Alexander Douglas · Grand Rapids, MIBuilt 1969 · S/N 28-25749N8884DJ C Aero LLC · Yelm, WABuilt 1958 · S/N 6354N8884NDubois Jerry · Oklahoma City, OKBuilt 1969 · S/N 28-25750N8885HHoughton Patrick K · Villa Rica, GABuilt 1961 · S/N 24-2577N8885JWeise David D · Marion, TXBuilt 1965 · S/N 28-2859N8887JWeskap LLC · West Grove, PABuilt 1965 · S/N 28-2862N8888JSnapp Steve J · Los Alamos, NMS/N 28-2863N8888YPriebe Rodney M · Wasilla, AKBuilt 1973 · S/N 18-7409028
Back to AD 79-10-03 R2