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.

N34732Kohles Terrance · Portsmouth, IABuilt 1973 · S/N 17701966N34735Stramer Todd Personal Representative · Hazelton, NDBuilt 1973 · S/N 17701968N34737Seareylife LLC · Orlando, FLBuilt 1973 · S/N 17701969N34739Flying Pterodactyl LLC · Sarasota, FLBuilt 1973 · S/N 17701971N3473EVenture North Aviation LLC · Cloquet, MNBuilt 1955 · S/N 18-4262N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N3473RBrooks Gregory Keith · Green Cove Springs, FLBuilt 1967 · S/N 18258773N3473WGades Gary A · Montevideo, MNBuilt 1980 · S/N 18504080N3473XStoner Jon L · Pocatello, IDBuilt 1966 · S/N 1149N3473ZHanson John G · Marion, MTBuilt 1960 · S/N 18-7298N34743Rogers Ronald · Olney, TXFirst renewal noticeBuilt 1973 · S/N 17701972N34749Hardy Camden L · Seattle, WABuilt 1973 · S/N 17701975N3474MSolverson Britt B · Hazel Green, WIBuilt 1978 · S/N 28-7890303N3474YHanson Dan B Jr · Lusk, WYS/N 18051974N347513218t Inc · Omaha, NEBuilt 1973 · S/N 17701977N34753Vanhook Enterprises Inc · West Somerset, KYBuilt 1973 · S/N 17701979N34756Devereaux Christopher L · Raleigh, NCBuilt 1973 · S/N 17701982N34757James David C · Redlands, CABuilt 1973 · S/N 17701983N34758Vaccaro Glen J · Trinidad, COBuilt 1973 · S/N 17701984N34759Steckbeck Richard James · Enid, OKBuilt 1973 · S/N 17701985N3475EOlmedo Refugio Junior · Lancaster, CABuilt 1978 · S/N 17271561N3475FSanguinetti Mark · Winnsboro, LAS/N 18257475N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449N3475RMccullough Hugh J · Glennville, GABuilt 1968 · S/N 18258775N3475SSmith Reine K IV · Lockhart, TXBuilt 1965 · S/N 18255875N3475TWitt Jerry D · Marana, AZBuilt 1968 · S/N 17700775N3475XSilva Phillip S · Henderson, NVBuilt 1967 · S/N 670249N34760Abrahamson Allen G · Frisco, TXBuilt 1973 · S/N 17701986N34761Griffin Jeremiah L · Titus, ALBuilt 1973 · S/N 17701987N34762Cadamore Brian S · Cabot, PABuilt 1973 · S/N 17701988N34764York Aviators LLC · York, PABuilt 1973 · S/N 17701990N34766Robbins Paul A · Nacogdoches, TXS/N 17701991N34767Tschida Thomas R · Mendota Heights, MNBuilt 1973 · S/N 17701992N3476AIsaacs Eugene E · Key West, FLS/N CE-294N3476FDickens Charles L · Panama City Beach, FLS/N 18257476N3476RTibbs Properties LLC · Franklin, LABuilt 1968 · S/N 18258776N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876N3476WFletcher Gayle J · Conroe, TXBuilt 1966 · S/N 32-352N3476XChristy Parker Consulting LLC · Wake Forest, NCBuilt 1966 · S/N 3419N34770Gustin Brian K · Camdenton, MOBuilt 1973 · S/N 17701994N34772Mlaskoch Air LLC · Willow River, MNBuilt 1973 · S/N 17701996N34774Dunn Gregory Scott · Wooster, OHBuilt 1973 · S/N 17701998N34777Trautmann Glenn K · Highlands Ranch, COBuilt 1973 · S/N 17702000N3477ARagsdale Lincoln J Jr · Phoenix, AZBuilt 1969 · S/N E-183N3477EMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 17271563N3477FFlying T LLC · Albuquerque, NMBuilt 1966 · S/N 18257477N3477KToles Richard O · Wolcott, NYBuilt 1967 · S/N 28-23572N3477MCapella LLC · Parkville, MOBuilt 1978 · S/N 28-7890305N3477SN3477s Inc · Dalton Gardens, IDS/N 18255877N3477WStevens Brad · Chandler, AZBuilt 1966 · S/N 32-353
Back to AD 2007-04-19 R1