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.

N264DDSigman Aviation LLC · Pelion, SCBuilt 1997 · S/N 1098N264DMPersons Richard A · Arroyo Grande, CAFirst renewal noticeBuilt 1988 · S/N 264N264EBReady Aim Flyer LLC · New Castle, DEBuilt 2003 · S/N 24790N264EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13504N264EXFull Circle Aero LLC · Wilmington, DEBuilt 2001 · S/N 139N264FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020260N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264N264JSAllen James M · Gilmanton, NHBuilt 1993 · S/N 21522N264LWilder Paul D · Chattanooga, TNBuilt 2003 · S/N 23323N264MSanterre Phillip E Trustee · Chugiak, AKBuilt 1958 · S/N 50236N264MAShaffer John C · Talkeetna, AKBuilt 2004 · S/N 482-2004N264MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881362N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069N264NSKelley Shawn J · Cottage Grove, ORBuilt 2003 · S/N SK951-002278N264QChan Hung-Chun · Orem, UTBuilt 1966 · S/N TC-987N264RBAerostar International Inc · Lewes, DEBuilt 2006 · S/N 11477N264RHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2017 · S/N 2479N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258N264SBCkw Aviation LLC · Dalhart, TXS/N TE-1125N264SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13407N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190N264USTecnam US Inc · Sebring, FLBuilt 2021 · S/N 164/USN264WYMcgowan Bruce Trustee · Solvang, CABuilt 2016 · S/N 3264N264XWignall Fred J · Newcastle, WYBuilt 2002 · S/N 2114N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601N26507Musgrave John R · Morris, ILS/N 1958N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750N2650GNewkirk Kevin J · Manhattan, KSS/N 51950N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988N2650WBrown Danny L · Wichita, KSS/N 983N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307N2651ZHelburg Michael L · Libby, MTS/N 1004-77N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063N2652WRegistered aircraftBuilt 1966 · S/N 3308N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853N2653TValley Aircraft Restoration Society Inc · Phoenix, AZBuilt 1971 · S/N 28-7210001N2653WDyer Perri P · Argyle, TXS/N 984
Back to AD 2007-04-19 R1