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.

N42279Keller Mark D · Ellensburg, WABuilt 1968 · S/N 18258940N4227JRoberts Richard M · Plains, KSS/N 28-22576N4227KKnott John A · Waller, TXBuilt 1981 · S/N 602N4227QSchoenfeld Paul E · Midvale, UTBuilt 1971 · S/N 17260127N4227ZBavarian Barnstormers Inc · North Fort Myers, FLBuilt 1966 · S/N 18-8452N42280Altitude Addiction LLC · Harker Heights, TXBuilt 1968 · S/N 18258941N42285Clemenson Christopher James · West Fargo, NDBuilt 1968 · S/N 18258944N4228742287 LLC · Kettle Falls, WABuilt 1968 · S/N 18258945N42288Welsh Christopher R · Cresson, TXBuilt 1996 · S/N 1329N4228CBurhmann Joel David · Justin, TXBuilt 1974 · S/N 414-0528N4228QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260128N4228ZEastern Aviation Fuels Inc · New Bern, NCBuilt 1966 · S/N 18-8453N42291Palmer Don W · Penhook, VABuilt 1968 · S/N 18258946N42292Breier Michael D · Pasco, WABuilt 1974 · S/N 17264168N42293N42293 LLC · Hillsboro, ORBuilt 1968 · S/N 18258948N42295Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18258950N42296Robinson Fredrick J · Morris, ILBuilt 1968 · S/N 18258951N4229HGranger Andrew J · Denver, COBuilt 1948 · S/N 14-32N4229TRobinson Lee B · Kerrville, TXBuilt 1971 · S/N 28-7225098N4229ZToney William M II · Gig Harbor, WABuilt 1966 · S/N 18-8454N422ARDaly John H · Pukwana, SDBuilt 2001 · S/N 2131N422ATDec Flight Services LLC · Sandy Springs, GABuilt 2000 · S/N E-3333N422BPreston Richard K Trustee · Albuquerque, NMS/N 17268342N422BBSullins David D · King George, VABuilt 1984 · S/N 342N422BKCarroll John H · Newnan, GABuilt 1972 · S/N 18502121N422BWBravo Whiskey LLC · Gilbert, AZBuilt 1968 · S/N 21059100N422CBHeavy Metal Air LLC · Farmingdale, NYBuilt 2005 · S/N 172S10011N422CCRegistered aircraftS/N 2170N422CDMachedge Flight Sim Training LLC · Pell City, ALBuilt 1981 · S/N 28-8190272N422CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496438N422DBHarron Eric J · Austin, TXBuilt 1978 · S/N E-1386N422DCJohnson John K · Portland, ORBuilt 1959 · S/N D-5843N422DJFerrer Michael V · Fort Worth, TXBuilt 1979 · S/N 28-7911281N422DMWarren Clifton · Camarillo, CABuilt 2003 · S/N 004N422DXMerten Aviation Services LLC · Holtville, CABuilt 2009 · S/N 12699N422EJAdams A David · Tallahassee, FLBuilt 1979 · S/N 28-7990585N422EKWebster Eric Thomas · Austin, TXS/N 1249N422ELLeeper Fred · Douglass, KSBuilt 2021 · S/N 82906N422ENHicks Avionics LLC · Dawson, GAS/N 1241N422EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2017 · S/N 172S12022N422FIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 0711N422FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC022N422GJBack Country Aviation LLC · Kikiski, AKFirst renewal noticeBuilt 2004 · S/N 1385RN422GRHolden Virgil Gary Trustee · Upland, CABuilt 1966 · S/N D-8243N422HDaniel Harwell Md Pllc DBA · Tulsa, OKBuilt 1981 · S/N 18268053N422HABrightwater Enterprises LLC · Lakeway, TXBuilt 2005 · S/N 172S9830N422JLeecorp Transport LLC · Naples, FLBuilt 1977 · S/N 18266172N422KAStewart Scott A · Anchorage, AKBuilt 1975 · S/N 18-7509009N422KBKaempfer Melissa Jean · Lenoir City, TNBuilt 1999 · S/N 18280512N422LBMckeever Gregory Allen · Holly Springs, NCFirst renewal noticeBuilt 1981 · S/N 32R-8113030
Back to AD 2007-04-19 R1