AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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.

N2742RCollinsworth Frederick W · Broken Arrow, OKBuilt 1969 · S/N 28R-35281N2742WStraub R L DBA · Stanton, TXBuilt 1966 · S/N 1040N2742XCallaway Scott T · Soldotna, AKBuilt 1965 · S/N 18051542N2743FRiddle Danny M Trustee · Ruby Valley, NVBuilt 1965 · S/N 18256843N2743GFleetwood Jack · Hutto, TXBuilt 1959 · S/N 52043N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690N2743QSzigeti David J · Gaylordsville, CTBuilt 1967 · S/N 18257943N2743XErb Weston Scott Trustee · Wasilla, AKBuilt 1965 · S/N 18051543N2744Morgan Jeff P · Justin, TXBuilt 2017 · S/N 2883N27446Evans William Henry Jr · Gardendale, TXBuilt 1939 · S/N 2088N2744CBrewer Farms · Thompson, MOBuilt 1978 · S/N R18200224N2744FTyson Jacob N · Molena, GABuilt 1965 · S/N 18256844N2744GShelton Jeffrey A · Denali Park, AKS/N 52044N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644N2744KLucas Greg C · Elmore City, OKS/N 18053057N2744PTouchdown LLC · Pls Vrds Est, CABuilt 1979 · S/N 340A0941N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644N2744XAccelerated Slipstream LLC · Livermore, CABuilt 1981 · S/N 414A0812N2744YDe Vuyst Richard C · Pampa, TXBuilt 1979 · S/N 340A0943N27457Felix Margarita G · Nogales, AZBuilt 1981 · S/N 414A0813N2745FAlexander Production Co · San Antonio, TXBuilt 1979 · S/N 340A0949N2745GKj3 Air LLC · Mitchell, SDBuilt 1980 · S/N 414A0622N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586N2745PColgan Paulette · Tucson, AZBuilt 2010 · S/N 90142N2745QAero Docs LLC · Butte, MTBuilt 1967 · S/N 18257945N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78N2746CChen Mark · Plano, TXBuilt 1998 · S/N 17280587N2746GMchugh Rick M · Enumclaw, WABuilt 1959 · S/N 52046N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053N2746TFranklin Ronald C · Las Vegas, NVBuilt 1967 · S/N D-8460N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143N2747JRamstad Phillip J Trustee · Anchorage, AKBuilt 1969 · S/N 185-1497N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054N2747QMosier Michael J · Kalamazoo, MIBuilt 1967 · S/N 18257947N2747RWilliams Dwight M · Paragould, ARS/N 18280343N2747XTaylor Joseph Baker · Anchorage, AKBuilt 1965 · S/N 18051547N2747YJennflight Inc · Chagrin Falls, OHS/N TD-96N2748FWirth Gerald J Trustee · New Lenox, ILBuilt 1998 · S/N 18280345N2748GNoe Aviation LLC · Vinton, IAS/N 152N2748PHess Gary A · Petoskey, MIBuilt 1955 · S/N 22-3055N2748QDavie Walter C · Los Angeles, CABuilt 1967 · S/N 18257948N2748WZweifel Jonathan R · Chandler, AZBuilt 1966 · S/N 3347N2749EB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17271314N2749FSummersell Chadwick G · Chattanooga, TNBuilt 1965 · S/N 18256849N2749JFithian Cody D · Wasilla, AKBuilt 1969 · S/N 185-1499N2749KAero Applicators Inc · Sterling, COBuilt 1979 · S/N 18053059N2749MBeebe Richard W II · Hamden, CTBuilt 2001 · S/N 5057N2749YBaker Paul D · Grand Prairie, TXBuilt 1958 · S/N TD-105
Back to AD 2007-04-19 R1