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.

N521JCRasmussen Group · Des Moines, IABuilt 2008 · S/N TH-2242N521JDH&G Farms Inc · Corcoran, CABuilt 1998 · S/N 172S8027N521JPJpm Flying Service LLC · Marine, ILBuilt 1976 · S/N 18052762N521JVCardinal Enterprise LLC · Jackson, WYBuilt 2023 · S/N 14617N521KGSimpson Joseph E · Knoxville, TNBuilt 2024 · S/N 42203N521KMMcmorries Kyle P · Nacogdoches, TXBuilt 1984 · S/N 21064868N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519N521LDStar Marianas Air Inc · Tinian, MPBuilt 1977 · S/N 17269184N521LSGlobal Aerials Inc · Pembroke Pines, FLBuilt 2015 · S/N 13907N521MCBarr Air Patrol LLC · Mesquite, TXBuilt 2004 · S/N 172S9730N521MMEagle Topflight LLC · Cape Girardeau, MOBuilt 1988 · S/N 4608104N521MWGruetzmacher Marcus Collin · Denton, TXFirst renewal noticeBuilt 1960 · S/N 24-1978N521NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10975N521PWDoghouse Aviation LLC · Vienna, VABuilt 1988 · S/N E-2434N521RLCherry Creek School District No 5 · Greenwood Village, COS/N 0216N521SCHarrison Ted W · Grapevine, TXBuilt 1977 · S/N 21062343N521SDMedary Aviation LLC · Brookings, SDBuilt 2024 · S/N 172S13137N521SGPerfect Landing Aviation LLC · Highlands Ranch, COS/N 29-0362N521STMusick Aircraft Corp · Greenwood, MSS/N 24584N521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673N521TRRizzo Anthony M · Winter Haven, FLS/N DMO379N521TTCaras Tiger LLC · Homestead, FLS/N 10128N521TYRegistration Pending · Olympia, WARegistration pendingBuilt 2023 · S/N M5-5-9M5/10M5-5018N521VRMyers Jonathan A · Dieterich, ILBuilt 1965 · S/N D-7922N521VTSeaplanes R Fun Inc · Wilmington, DEBuilt 1957 · S/N 50055N521WSCmt Properties LLC · Laurel, MSBuilt 1997 · S/N TH-1836N521XPalmetto Aces Flying Club LLC · Hilton Head Island, SCBuilt 1978 · S/N 28-7911038N521ZHoffner Flying Inc · Yankton, SDBuilt 2002 · S/N 0176N52200Pol Guillermo L · Miami, FLBuilt 1980 · S/N 17274433N52204Rench Eugene G · Owosso, MIS/N 18262452N52208Eastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9208N5220BFolbre Frank S · Millsap, TXS/N 1083N5220EMcgee Kirk S · Anchorage, AKBuilt 1959 · S/N 50520N5220LR & J Services LLC · Tracy, CABuilt 1967 · S/N 28-4513N5220PStancil Thomas E III · Winterville, NCBuilt 1958 · S/N 24-247N5220RChaz L Enterprises LLC · Ringwood, NJBuilt 1974 · S/N 17263434N5220THammond Michael R · Tigard, ORS/N 28-7225360N5220WHosemann Aaron · Riverview, FLBuilt 1961 · S/N 28-257N5220XCartwheel Aviation LLC · Boise, IDBuilt 1992 · S/N 694-92N5220YHart Robert D · The Villages, FLBuilt 1962 · S/N 27-2269N52210Pressly Joel D · Sunriver, ORS/N 24129N52213Rosner Peter · Acton, MABuilt 1973 · S/N 18262457N52214Peterson Todd W · Beavercreek, ORBuilt 1973 · S/N 18262458N52217Mustang Sally Aviation LLC · Camden, SCBuilt 1980 · S/N 17274441N52218Jej Leasing LLC · Bangor, MEBuilt 1980 · S/N 17274442N52219Warren Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274443N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778N5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514N5221RDunaway Jeffrey W · Bremerton, WABuilt 1974 · S/N 17263435
Back to AD 2007-04-19 R1