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.

N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107N339CHPitch And Power LLC · Indianapolis, INBuilt 1977 · S/N 18265213N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470N339DGRegistered aircraftS/N P21000434N339DLFriedrich Robin K · Houston, TXS/N 90206N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017N339GOrsolits Robert M · Maitland, FLBuilt 2011 · S/N 361N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N339JSMountain Taxi LLC · South Jordan, UTS/N 72238N339LLThro Flight Inc · Boca Raton, FLBuilt 2025 · S/N 14883N339MEShinkle Gordon · Gillette, WYBuilt 2000 · S/N 18280734N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012N339PJWallace James R · Aumsville, ORBuilt 2006 · S/N 90589N339RVBillips Robert A · Bluefield, VABuilt 2016 · S/N 92170N339SABig River Farms Inc · Natchez, MSBuilt 1999 · S/N 18280508N339SCSea Seven LLC · Weatherford, TXBuilt 2014 · S/N SC007N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453N339WLawson Richard Brandon · Ararat, NCBuilt 2000 · S/N 5657N33ANeo Terra Aviation LLC · Setauket, NYBuilt 1988 · S/N CE-1222N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412N33AKMoses And Associates Inc · Gainesville, FLBuilt 1980 · S/N 61P08508163448N33ANBarnes Gary Aaron · Huntsville, ALBuilt 1993 · S/N 625-320-0370FBN33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784N33AVMaurer Sara Ann · Anchorage, AKBuilt 1996 · S/N 1332N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136N33CVMaintain Aviation LLC · Pomona, MOBuilt 1992 · S/N CE-1678N33CXK & S Irrigation Inc DBA · Higbee, MOS/N 10569N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33DMGray Chad T · Garden Valley, IDBuilt 1968 · S/N 18259170N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182N33EEDes Moines Skydivers LLC · Des Moines, IABuilt 1969 · S/N 18259998N33EFJarosak Theodore J Jr · Portage, INBuilt 1985 · S/N 1345N33EJReinke Bradley H · Pascagoula, MSBuilt 1993 · S/N CE-1721N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770
Back to AD 2007-04-19 R1