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.

N3695PHanafi Robert A · Wellton, AZBuilt 1955 · S/N 18-4597N3695RPeake Aviation LLC · Flint, MIBuilt 1969 · S/N 28-5400N3695YAffordable Aviation Corp · Moriches, NYBuilt 1963 · S/N 21058195N3695ZSherrier Mark A · Tehachapi, CABuilt 1961 · S/N 18-7430N3696Devries Scott T · Brighton, COS/N LM-2N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494N36968Msb Aviation LLC · Middletown, DEBuilt 1980 · S/N CE-924N3696CTb Services LLC · Huntsville, ALBuilt 1978 · S/N R18200313N3696LP51d Mustang LLC · Bigfork, MTBuilt 1980 · S/N TJ-310N3696WSantos Marc · Lincoln, RIBuilt 1966 · S/N 32-608N3696ZGardner Thomas G · Lincoln, MEBuilt 1960 · S/N 18-7431N3697YSmotrich Gary A · Yardley, PABuilt 1980 · S/N M-2294N3697ZNorthern Wilderness Aviation LLC · Tok, AKBuilt 1960 · S/N 18-7433N3698CTomlinson John J · Kent, WABuilt 1954 · S/N 31197N3698D98d Aviation LLC · Dyersburg, TNBuilt 1980 · S/N E1746XLN3698MPetersen Mark A · Willow, AKBuilt 1947 · S/N 12-2643N3698NKienitz David A · Buffalo Lake, MNBuilt 1967 · S/N 680041N3698QGribble David A · Marion, IABuilt 1967 · S/N MA-281N3698UJk Fly LLC · Abie, NEBuilt 1963 · S/N 18255098N3698ZChippewa Aero LLC · Montevideo, MNBuilt 1960 · S/N 18-7434N3699AWeskap Hangar Management LLC · West Grove, PABuilt 1979 · S/N E-1621N3699GInternational Aerospace Solutions LLC · Jupiter Inlet, FLBuilt 1980 · S/N EA-151N3699ML A B Flying Service Inc · Renton, WABuilt 1978 · S/N 28-7890324N3699QHillner Kevin D · Marengo, ILS/N MA-282N3699YAmfreight Logistics LLC · Deltona, FLBuilt 1963 · S/N 21058199N3699ZWharton Conrad J · Leavenworth, WABuilt 1960 · S/N 18-7435N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479N369ANJet Aircraft Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280696N369ATJogger Industries LLC · Sherwood, NDBuilt 2021 · S/N 14488N369BBRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N TD-713N369BFPedersen Andrew T · Apex, NCS/N 3660N369BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881769N369CParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020223N369CMOharra Robert J · Buckley, WABuilt 1969 · S/N 18052058N369CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12346N369DADuan Ran · Bothell, WABuilt 2023 · S/N 172S13041N369DMHoll Brian E · Chugiak, AKBuilt 1975 · S/N 830-75N369DSCross Douglas J · Yucaipa, CABuilt 1997 · S/N 369N369ELErickson Logging Inc · Gig Harbor, WAFirst renewal noticeS/N 1590N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062N369FSOne Tango Mike LLC · Martinez, CABuilt 2005 · S/N 90810N369GGulley Cameron L · Eastland, TXBuilt 1968 · S/N E-44N369GTTokar Gary J · Howell, MIBuilt 1960 · S/N 52608N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049N369JLFt Aviation LLC · Dyersburg, TNS/N 2531N369JMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 0087N369JPWaddell Patrick G · Seattle, WABuilt 2003 · S/N 40.310N369KSkydive Inc · Eagle Creek, ORBuilt 1963 · S/N 18254634N369KCCarver Clarence K · Lutz, FLBuilt 2025 · S/N 60264N369KGRegistered aircraftBuilt 1995 · S/N 23008C
Back to AD 2007-04-19 R1