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.

N574MMMyers Benny R · Wasilla, AKBuilt 2023 · S/N 100N574MTGrow Michael J · Palmer, AKBuilt 1967 · S/N 185-1247N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943N574PRSoto Angel L · Las Piedras, PRBuilt 1965 · S/N 32-241N574RBGod'S Country Aviation LLC · Trapper Creek, AKBuilt 2018 · S/N 4133CN574RHRob Holland Ultimate Airshows LLC · Coushatta, LABuilt 2021 · S/N MX2-002N574RJJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4888N574SBRj Group Investments LLC · Lawton, OKBuilt 1972 · S/N E-312N574STState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606116N574TMcallister Todd K · Grangeville, IDBuilt 1961 · S/N D-6748N574WBDeal Timothy E · Anchorage, AKBuilt 1957 · S/N 34507N574WDLathrop Frederic W · Dayton, OHBuilt 1997 · S/N TH-1831N57503Martin William A · Nashville, TNBuilt 1973 · S/N 95-73N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N5750KSamons David M · Phoenix, AZBuilt 1964 · S/N D-7538N5750MStites Holdings LLC · Seattle, WAS/N 24-1457N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077N57515Peterson Dean · Gothenburg, NEBuilt 1973 · S/N 380-73N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N5751BMacon Michael D · Sisters, ORBuilt 1956 · S/N 33751N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751JB & H Drilg · Winnsboro, LABuilt 1971 · S/N 21059451N5751KDetloff Martin P · Kaukauna, WIBuilt 1964 · S/N D-7539N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N5752BWallace Thad Joseph · Mount Shasta, CABuilt 1956 · S/N 33752N5752MColeman William J · Redondo Beach, CABuilt 1968 · S/N 310P0052N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078N5752URiggin Flight Service · Madison, SDS/N 28-26575N57532N57532 LLC · Wasilla, AKS/N 18-7809089N57534Sale Reported · Drake, NDSale reported, pending cancellationBuilt 1978 · S/N 18-7809090N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056N5753KSale Reported · Fort Worth, TXSale reportedBuilt 1964 · S/N D-7542N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490N5753ZFereday Richard R · Mccall, IDBuilt 1963 · S/N 18-8026N5754DRocca John · Box Elder, SDS/N 22-4454N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057N5754QHamm Martin C · Southport, NCBuilt 1965 · S/N 3079N5754UAuthement Michael Ray · Pecos, TXBuilt 1969 · S/N 28-26577N5754VWeiser Steven Clark · Hutto, TXBuilt 1966 · S/N MA-20N57550Freese Marc Alan · Fulda, MNBuilt 1977 · S/N 18-7709122N57555Norden Paul E · Anchorage, AKS/N 18-7709124N5755DNathan Timothy A · Arnold, MDBuilt 1956 · S/N 22-4455N5755GDestination Alaska Air Service LLC · Homer, AKS/N U20603758N5755JBagge John A · Independence, IABuilt 1974 · S/N 18263520N5755KBrooks Auto Parts Inc · Douglas, GABuilt 1964 · S/N TC-738N5755UKyzer Aviation Holdings LLC · Fort Mill, SCS/N 28-26579
Back to AD 2007-04-19 R1