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.

N3256JMyers Benny R · Wasilla, AKBuilt 1966 · S/N 15065956N3256TWoodfill Kyle · Lake Jackson, TXBuilt 1967 · S/N 17700556N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256N3256ZChristensen Robert P · Ashton, IDBuilt 1959 · S/N 22-7205N32573Zarafshar Keyvan · Sterling, VAS/N 28-7515190N32574Miloud Chadd K · Fort Worth, TXBuilt 1974 · S/N 28-7515191N32575Mgps Aero LLC · Wilmington, DES/N 28-7515192N32579Ab3 Resources Inc · Unionville, PABuilt 2022 · S/N 30064CN3257BVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1954 · S/N 18-3275N3257DAlaska Dall Sheep Guides LLC · Anchorage, AKBuilt 1955 · S/N 32055N3257EFlycarolina LLC · Concord, NCBuilt 1978 · S/N 17271482N3257FBrandon M Ten Hoopen · Bay Shore, NYBuilt 1967 · S/N 670050N3257SFelton Frank B III · Thorndale, TXBuilt 1964 · S/N 18255757N3257XN1002q LLC · Lake Butler, FLFirst renewal noticeBuilt 1967 · S/N 310L-0107N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257N32585Aero Services Lc · Woods Cross, UTS/N 28-7515194N32588Miloud Chadd K · Fort Worth, TXBuilt 1974 · S/N 28-7515195N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758N3258WDiaz Andy · Kansas City, MOBuilt 1965 · S/N 32-81N3258XWrenn William H · Baytown, TXFirst renewal noticeS/N 310L-0108N3258YByra Paula A · Pagosa Springs, COS/N 18254258N32590Schlickmann Christian · Brookhaven, GABuilt 1974 · S/N 28-7515196N325925niner2 Aviation LLC · Washington, DCBuilt 1974 · S/N 28-7505075N3259DLutes Stacy J · Mooresville, NCBuilt 1955 · S/N 32057N3259FBrown Scott J · Liberty, SCS/N 670052N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659N3259YGrantham William Edward · Doerun, GAS/N 18254259N325AVSilver City Flying Club Inc · New Hartford, CTBuilt 1979 · S/N 28-7990346N325BEPerformance Backcountry Aviation LLC · Zionsville, INBuilt 2004 · S/N 466-2004N325BFSunshine Flyer LLC · Denver, COBuilt 2002 · S/N 6051N325CVajdos Nicholas · Karnes City, TXS/N 24-1082N325CALucchesi Vincent · Oakham, MABuilt 1995 · S/N 3246009N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292N325DDQuick Michael D · Middletown, CAS/N 21062748N325GUsda-Aphis-Ws · Cedar City, UTBuilt 2010 · S/N CC18-0042N325JWKlug Transport Inc · Farmington, MOBuilt 2012 · S/N TH-2340N325KMorris Timothy J · Fairfield, OHBuilt 2009 · S/N 102N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825N325LAPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2019 · S/N 4496487N325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 27-7305149N325MBPearl Aire LLC · Port Orange, FLBuilt 2015 · S/N 91664N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N325MMBirdie Aviation LLC · Marble Hill, GABuilt 2007 · S/N 18281907N325PLTargia Kerry Marie · Statesville, NCS/N 3441N325RGaspar Robert M · Hillsborough, NJBuilt 2013 · S/N 0699020N325RHHensley Roger A · Rosamond, CABuilt 2016 · S/N 543-320-290N325RPN325rp Corp · Willow Spring, NCBuilt 1985 · S/N P21000848N325RVPerry Phillip W · Mc Gregor, TXBuilt 2017 · S/N 40750N325SBPaul Timothy · Garrettsville, OHBuilt 2002 · S/N 0001
Back to AD 2007-04-19 R1