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.

N2643FWortham Bethany S · Soldotna, AKBuilt 1965 · S/N 18256743N2643GBorland Gregg A · Elkhart Lake, WIBuilt 1959 · S/N 51943N2643KWashington Walt W · Collierville, TNBuilt 1978 · S/N 18053023N2643QOst Jesse E · Hunter, KSBuilt 1966 · S/N 18257843N2643RNorthern Wings LLC · Spokane, WABuilt 1967 · S/N 18258343N2643YCompany Plane LLC · Wisconsin Rapids, WIS/N 310R1687N2643ZPolizzi Christopher I · Peachtree City, GABuilt 1979 · S/N 310R1688N26440Nester Christopher J · Mount Washington, KYBuilt 1978 · S/N AA5A0591N2644MFaust Kevin C · Long Prairie, MNBuilt 1998 · S/N 23034N2644RColler Randy L · Jackson, MIBuilt 1967 · S/N 18258344N2644VCrosby David · Potomac, MDBuilt 1979 · S/N 310R1812N2644WMoran Robert D Jr · Plano, TXBuilt 1966 · S/N 979N26450Km Aero Inc · Kalispell, MTBuilt 1978 · S/N AA5A0596N26454Camarda Edward W · Conroe, TXBuilt 1978 · S/N AA5A0598N26456Coleman Edward H · Tulare, CABuilt 1978 · S/N AA5A0600N2645FMichel John Vernon III · Westminster, MDBuilt 1965 · S/N 18256745N2645GMurdoch Kyle · Burns, WYBuilt 1959 · S/N 51945N2645KFowlkes John M Trustee · Marfa, TXBuilt 1978 · S/N 18053024N2645QSigman Kenneth M · Birmingham, ALBuilt 1977 · S/N 28-7790411N26465Registered aircraftBuilt 1978 · S/N AA5A0612N2646FAmerican Driveaway LLC · Cowden, ILS/N 18256746N26471N26471 LLC · Versailles, KYBuilt 1978 · S/N AA5A0615N26479N24679 LLC · North Royalton, OHBuilt 1978 · S/N AA5A0619N2647FGayneaux Kelly J · Midland, TXS/N 18256747N2647GAllen Steven L · Thatcher, AZBuilt 1959 · S/N 51947N2647KBoice Petroleum Consulting LLC · Pinedale, WYS/N 18053025N2647PTrinkle Aviation LLC · Kingsburg, CABuilt 1955 · S/N 22-2985N2647RSaber Wings LLC · Sacramento, CABuilt 1967 · S/N 18258347N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578N2648FLincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1965 · S/N 18256748N2648QBuck Irrigation Inc · Elkhart, KSBuilt 1966 · S/N 18257848N2648WDeghetto Richard D · Hopkinsville, KYBuilt 1966 · S/N 981N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676N26498Dodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 0836N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749N2649GSwanson Gregory N · Meridian, IDS/N 51949N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599N2649PHoffmann Greg L · Centennial, COBuilt 1955 · S/N 22-2987N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349N2649WTeeter Joseph Jerald · Lisbon, OHBuilt 1966 · S/N 982N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149N2649ZHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0333N264AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881759N264APRotor Leasing LLC · Indianapolis, INBuilt 2024 · S/N 14818N264ATAirline Transport Prof Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496088N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035N264CMVasquez Arthur D · Ocala, FLBuilt 1978 · S/N AA5A0588N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716N264DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843825
Back to AD 2007-04-19 R1