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.

N313WFSalisbury Peter R · White Bear Lake, MNBuilt 2001 · S/N 879-2001N313WMKafer Mark T · Colleyville, TXBuilt 1965 · S/N 28-2678N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350N313YZTextron Aviation Employees' Flying Club Inc · Wichita, KSBuilt 2024 · S/N 172S13179N313ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881640N31400Druidia Group LLC · Downingtown, PABuilt 1978 · S/N 28-7816557N31401Fox Flying Club Inc · Wheaton, ILBuilt 1978 · S/N 28R-7837234N31407Montei Nicholas P · Caro, MIS/N 32-7840130N3140CAthens William A · Missoula, MTBuilt 1954 · S/N 30939N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240N3140SLavell Michael J · Blue Mounds, WIS/N 18255640N3140TSuggs Helen T · Jacksonville, FLBuilt 1967 · S/N 17700440N3140YParker Mccrum LLC · Eugene, ORBuilt 1962 · S/N 18254140N3140ZHoyt Kenneth B · Marion, KSBuilt 1959 · S/N 22-7084N31419North Fork Helicopters Ltd · Cutchogue, NYBuilt 2006 · S/N 11381N3141DNelson Donald W · Aurora, COBuilt 1955 · S/N 31939N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241N3141PDakota Aero Inc · Wilmington, DEBuilt 1957 · S/N 23-1069N3141RIncze Bela · Morgan Hill, CABuilt 1967 · S/N 18258541N3141SValley Excavation And Grading Inc · Chatsworth, CABuilt 1964 · S/N 18255641N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441N3141UMo2 Investing LLC · Springfield, MOS/N 18254541N3141ZKumbier Jenene R · Maxwell, IABuilt 1959 · S/N 22-7086N31429Leonard Gordon A · Anchorage, AKBuilt 1991 · S/N 20649N3142BScaled Composites LLC · Mojave, CABuilt 1982 · S/N 1N3142CItm Electronics Inc · Greenleaf, IDBuilt 1954 · S/N 30941N3142QRogers James · Summerfield, FLBuilt 1967 · S/N 18258142N3142RSharp Media Group LLC · Kansas City, MOS/N R18201117N3142SB&G Aircraft LLC · Greensboro, GABuilt 1964 · S/N 18255642N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442N3142YOdom Aviation Inc · Cabot, ARS/N 18254142N3143CAuron Chris · Naples, FLBuilt 1977 · S/N 1103N3143DRoland Ann J · Woodland, CAS/N SA1025-75013LFN3143QJlm Management LLC · Clarion, PABuilt 1967 · S/N 18258143N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543N3143WLoyd Marion S · Dumas, ARBuilt 1991 · S/N 1920N3143ZChristian Edward A · Evans, GABuilt 1959 · S/N 22-7088N31444Crossen John R · San Pedro, CABuilt 1988 · S/N CE-1277N31445Kuther Kenneth J · Nezperce, IDS/N 2176N31449Peterman Keith A · Taylorsville, KYBuilt 1978 · S/N 2178N3144HT And C Corp · Wilmington, DEFirst renewal noticeBuilt 1987 · S/N CE-1191N3144MWhite Ice Holdings LLC · Santa Rosa Beach, FLBuilt 1987 · S/N CE-1206N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444N3144VMike Smith Aviation International Inc · Napa, CABuilt 2002 · S/N 172S9123
Back to AD 2007-04-19 R1