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.

N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054N4053BCavenagh Thomas D · Lawton, OKBuilt 1975 · S/N 76-30797N4053DGardner Dale R · North Logan, UTBuilt 1957 · S/N 34753N4053FBluebird & Blue Skys LLC · St Simons Is, GABuilt 2023 · S/N 18283210N4053TSky High Helicopters LLC · Camarillo, CABuilt 2018 · S/N 30045N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865N4054BKing Ronald S Jr · Goldsby, OKBuilt 1976 · S/N 76-30831N4054DBass Edward J · Richland, WABuilt 1958 · S/N 34754N4054GWorks Mark S · Cincinnati, OHBuilt 2023 · S/N 30095N4054XLongmire Vaughn H · Tampa, FLS/N 5154N4054ZBiggs Craig P · Preston, IDBuilt 1963 · S/N 18-8059N40552Peeler Jason B · Flooresville, TXS/N 18-7509126N40558Hill Casey J · Anchorage, AKBuilt 1975 · S/N 18-7509127N4055DLoup Technologies Inc · Longmont, COBuilt 1957 · S/N 34755N4055KHarris William R Jr · Salisbury, CTBuilt 2020 · S/N 2611N4055NKansara Sanjay · Coopersburg, PABuilt 2020 · S/N 2619N4055XAtlas Air LLC · Salt Lake City, UTBuilt 1974 · S/N 5055CN4055ZMartin Lawrence M · Clam Gulch, AKS/N 18-8060N4056BTesar Thomas J · Williamsport, TNBuilt 2022 · S/N 4866N4056MBarfield Anthur F · Fairborn, OHBuilt 1991 · S/N 1793N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617N4056VHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2023 · S/N 30093N4056XHolliday Ralph C III · Coppell, TXBuilt 1970 · S/N 5156N4056ZG & L Airborne Inc · Wilmington, DEBuilt 1963 · S/N 18-8064N40575Evans Samuel F · Iuka, MSBuilt 1976 · S/N 18-7709018N40579Burwell Jeffery S · Wasilla, AKBuilt 1976 · S/N 18-7509129N4057BKaler Wayne J · Sayville, NYBuilt 1974 · S/N 75-30739N4057CAberdeen Flying Service · Aberdeen, SDBuilt 1982 · S/N 414A0848N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027N4057SValley View LLC · Dover, DEBuilt 2023 · S/N 14689N4057YWalther Newell A · Wasilla, AKBuilt 1961 · S/N 185-0257N4057ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 18-8066N4058CHolt Tommy · Big Lake, TXBuilt 2021 · S/N 4860N4058DKenley Douglas T · Palmer, AKBuilt 1957 · S/N 34758N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168N4058XLeading Edge Aviation Foundation Inc · Mountain Home, ARFirst renewal noticeBuilt 1970 · S/N 5158N40592Rml Aircraft Inc · Staunton, VABuilt 1974 · S/N 27-7405337N4059BLyster Michael · Lake Havasu City, AZBuilt 1975 · S/N 76-30809N4059MTcwh Inc · Hachita, NMBuilt 2022 · S/N 4867N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110N405CDLbi Aviation Corp · Manahawkin, NJBuilt 2004 · S/N 0944N405CMHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3096N405CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282439N405DSDelaware State University · Dover, DEBuilt 1976 · S/N 28-7715243N405DTSkiles Carl A · Leander, TXS/N 17702389N405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FLBuilt 2012 · S/N 172S11154
Back to AD 2007-04-19 R1