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.

N34AXPw58 LLC · Dover, DEBuilt 1956 · S/N CG-141N34BMaresco International Corp · Alpha, NJBuilt 1952 · S/N G-17N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797N34BBMcvay Larry A · Boise, IDS/N 33725N34BLAmerican Asset Leasing LLC · Aurora, ORBuilt 2020 · S/N 172S12468N34BPAviation Insurance Managers Inc · Uniontown, OHBuilt 2014 · S/N TH-2420N34BQBettendorf Nicholas L · Mchenry, ILBuilt 1957 · S/N 144025N34BRIndustrial Reports Inc · Raleigh, NCBuilt 1981 · S/N CE-946N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34BVDessuit Franklin Jr · Mckinney, TXBuilt 1956 · S/N CG-152N34BWMaintenance Forecasters Inc · Falmouth, MIBuilt 1974 · S/N TC-1691N34BZDimich Milan C · Madison, SDBuilt 1958 · S/N CG-209N34C34 Charlie LLC · Helena, MTBuilt 2020 · S/N 3353N34CBCyrier John P · Lockhart, TXBuilt 1990 · S/N 2388N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34CFPayne James Michael · Twin Falls, IDBuilt 1974 · S/N 18052473N34CQRocky Mountain Warbirds LLC · Kalispell, MTBuilt 1958 · S/N CG-217N34CRRounds Donald C DBA · Waller, TXS/N G-758N34CURegistered aircraftBuilt 1958 · S/N CG-218N34CWRegistered aircraftBuilt 2018 · S/N 1170N34CXSchwerman Carl J · Oconomowoc, WIS/N CG-223N34CZN34cz LLC · Port Saint Lucie, FLBuilt 1992 · S/N 2662N34DAGlover William S · Mount Pleasant, TXBuilt 1958 · S/N 231469N34DBRegistered aircraftBuilt 2003 · S/N 29-0300N34DEStephens Justin R · Gatesville, TXBuilt 1988 · S/N DEG-1N34DKTennessee Aviation Services LLC · Sevierville, TNBuilt 1962 · S/N G-744N34DLAdlava LLC · Dover, OHBuilt 1966 · S/N 32-527N34DMGlotfelty John E · Durango, COBuilt 1959 · S/N 52329N34DNThomas Daniel Craig · Shady Shores, TXBuilt 2005 · S/N 498-2005N34DTSutton William E · Salinas, CABuilt 1953 · S/N G-114N34DVNelson Neil Wayne · Corvallis, ORBuilt 1988 · S/N 1619N34DWDarvis Enterprises LLC · Addison, TXBuilt 1980 · S/N R18201522N34DYMccormick Daniel · Salem, SCBuilt 1956 · S/N G-730N34EECodingflyboy LLC · Hayward, CABuilt 1966 · S/N 30-1138N34EMSpirit Rotorcraft LLC · Phoenix, AZBuilt 1955 · S/N 53-4150N34ESTough Old Bird Aviation LLC · Beavercreek, OHBuilt 1973 · S/N 34-7450078N34EVSilva Alexander J · Holly Springs, NCS/N G-16N34EXWilliams Dock G · Carmel Valley, CABuilt 2002 · S/N 165N34FCN34fc LLC · Boise, IDBuilt 1985 · S/N 182-68-498N34FFZwierlein Victor · Grand Prairie, TXBuilt 1976 · S/N U20603334N34FGState Of Alaska · Fairbanks, AKBuilt 1978 · S/N 18-7809041N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836N34FUWatson George E · Temecula, CABuilt 1956 · S/N BG-180N34FXPietig Jacob T · Santa Cruz, CABuilt 1998 · S/N 1692N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34GHRoofing Guys LLC · Marion, ILS/N 10134N34GRSeton Bruce B Jr · Port Townsend, WABuilt 2005 · S/N 55N34GSGhavi Enterprises Inc · Kenosha, WIBuilt 2016 · S/N 172S11662N34GTKawolis Paul F · Sutton, MAS/N G-697N34HCSummit Concepts Inc · Wilmington, DES/N 293-320-55
Back to AD 2007-04-19 R1