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.

N3517YRobles Serafin M · Cynthiana, KYBuilt 1962 · S/N 18254417N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414N35183Stone Industrial Contractors Inc · Savannah, GABuilt 2001 · S/N 18281051N35184Maliszewski William F · Independence, WIBuilt 2001 · S/N 18281002N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253N3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 20608163N3518FPortmann James R · St Louis Park, MNBuilt 1966 · S/N 18257518N3518YMcaninch Shawn R · Albia, IAFirst renewal noticeBuilt 1962 · S/N 18254418N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256N35193Mccormack Duncan M · Sunfield, MIS/N 17702257N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220N3519YWeber Larry F · New Paltz, NYBuilt 1962 · S/N 18254419N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351N351ATRegistered aircraftBuilt 1967 · S/N D-8507N351BRRosenbaum Robert · Chilmark, MABuilt 1997 · S/N 18280045N351CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283311N351CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281386N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N351JDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2707N351JMSeal Benjamin A · Grapevine, TXBuilt 2011 · S/N 81655N351JPParker Robert · Oklahoma City, OKBuilt 1976 · S/N TJ-51N351JSRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13355N351KCErickson Jason O · Mckinney, TXS/N 25114N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440N351PLifted Six Aviation LLC · Wilmington, DEBuilt 1962 · S/N D-6919N351PLBender Cliff · Plano, ILBuilt 1964 · S/N D-7302N351RRHolder Joiy R · Port Saint Lucie, FLBuilt 1964 · S/N TC-763N351RSSmith Herschel W III Md · Roswell, GABuilt 1966 · S/N D-8299N351TBLetter Ride LLC · Woodbury, MNBuilt 1995 · S/N 1708N351VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 28-8111056N351VBWudtke Dale A Trustee · Palos Park, ILBuilt 1970 · S/N D-9207N351WHDean John · Marana, AZBuilt 2002 · S/N 2309N351ZDofka Martin F III · Wheeling, WVBuilt 1960 · S/N CD-237N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N35206Mosaic Aviation LLC · Pelham, ALBuilt 2001 · S/N T18208089N3520FWood Forrest B · Cookson, OKBuilt 1966 · S/N 18257520N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920N3520WLyttle John W Jr · Chehalis, WABuilt 1966 · S/N 32-404N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270
Back to AD 2007-04-19 R1