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.

N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415N3797TMarshall Patrick R · Trail, ORBuilt 1967 · S/N 28R-30110N3797WCarter Thomas Shane · Pinetop, AZBuilt 1966 · S/N 32-725N3797YCockroft Roger · Baltimore, MDBuilt 1964 · S/N 21058297N3797ZMerriner Scott L · Anchorage, AKS/N 18-7492N3798KCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-23733N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416N3798UClapper Wesley J · Spokane, WABuilt 1963 · S/N 18255198N3798ZLovett William E · Homer, AKBuilt 1960 · S/N 18-7493N3799GRounds Chris · Waller, TXS/N G-709N3799KVea Lynn B · Mokena, ILBuilt 1967 · S/N 28-23734N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774N3799NCarlson John W · Wichita, KSBuilt 1967 · S/N 680122N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433N3799TFly 99t LLC · Pompano Beach, FLBuilt 1967 · S/N 28R-30112N3799XWilson Ricky A · Santa Teresa, NMS/N 297N3799ZConley Clint A · Spring Creek, NVBuilt 1960 · S/N 18-7495N379BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881779N379BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010083N379CCSmith Jason · Calliham, TXBuilt 2006 · S/N 1596N379CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2005 · S/N 1465N379GSSmith Adam · Rose Hill, KSS/N 2098N379HHack John C · Hobart, INBuilt 2016 · S/N M-II-2379N379JTN379jt LLC · Spokane, WABuilt 1978 · S/N 18503629N379LAM&K Commercial Diving LLC · Fair Haven, VTBuilt 1965 · S/N 28-2418N379MATurtle With Wings LLC · Yukon, OKBuilt 1999 · S/N 18280443N379MCAvex Holdings Heli Inc · Lewes, DEBuilt 1967 · S/N 67-18375N379NARonneberg Dave H · Santa Monica, CABuilt 2009 · S/N L-001N379NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881659N379NLDe Av8r LLC · Lewes, DEBuilt 1978 · S/N AA5B0822N379PFRegistered aircraftS/N 15069689N379SSky Chasers LLC · Mount Vernon, WABuilt 1980 · S/N R18201681N379SVSahara Viking Aviation LLC · Ocoee, FLBuilt 1979 · S/N 79-30945N379TCherney Cody L · Belleville, KSS/N D-7220N379TAChuck Smith Aircraft Inc · Torrance, CABuilt 2003 · S/N 172S9379N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616N379XCjr Air Service LLC · Saint Louis, MOBuilt 1976 · S/N 7011CN37AGWalker Robert J · West Finley, PABuilt 1990 · S/N AG-5N37ARFlowers Charles L · Yelm, WABuilt 1999 · S/N 1134N37AWCcx-2000-0111 LLC · Garberville, CABuilt 1999 · S/N 2020N37BAAmbler Robert L · San Diego, CABuilt 2001 · S/N 40020N37BCBarnes David L · Palmer, AKBuilt 1976 · S/N 18502965N37BHHuelsman Bradley D · Dayton, OHBuilt 1996 · S/N AE92-101N37BKChanging Horizons LLC · Helena, MTBuilt 2004 · S/N 10542N37BRC&D Pharmaceuticals Berry Inc · Berry, ALBuilt 1981 · S/N E-1860N37BSMatthew Davis · Asheville, NCBuilt 1974 · S/N E-548N37BTStucki Andre O · Deerfield Beach, FLBuilt 1981 · S/N 32R-8113083N37BYTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 951-2004N37CHDehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1460
Back to AD 2007-04-19 R1