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.

N4764URegistered aircraftBuilt 1965 · S/N 18051464N4764YOk3wire Properties LLC · Pensacola, FLBuilt 1973 · S/N D-9418N4765Rock Kevin M · Ashland, NEBuilt 1972 · S/N 14N47651Paris Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7816112N47653Fat Chance Airlines LLC · Hillsville, VAS/N 28-7816113N47656Adventure North Flying Service LLC · Aitkin, MNFirst renewal noticeBuilt 1977 · S/N 28-7816115N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940N4765JHall Jarrod L · Eufaula, OKBuilt 1967 · S/N MB-204N4765LClements Corbin B · Snyder, TXBuilt 1967 · S/N 28-4096N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513TN47660Edwards Mikiko S · Hoover, ALBuilt 1977 · S/N 28-7890111N47661Wopuna And Son LLC · Vancouver, WABuilt 1977 · S/N 28-7890112N47669Registered aircraftBuilt 1977 · S/N 32-7840011N4766DHutchison Frank J · Tucson, AZBuilt 1958 · S/N 34866N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872N4766FPrairie Fox Aviation LLC · Olathe, KSBuilt 1976 · S/N 28-7790060N4766HHay Christopher C · Sweet Home, ORBuilt 1979 · S/N 24-0843N4766MFx5 Construction & Excavation Inc · Decatur, TXBuilt 1978 · S/N E-1259N4766UMoore Murray H · Twain Harte, CABuilt 1964 · S/N 18051466N4767Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 0045N47673Falcon View Aviation LLC · Mckinney, TXBuilt 1977 · S/N 28-7816117N47674Sides Blake A · Jackson, TNBuilt 1977 · S/N 28-7816118N47675Czeck Steven S · New Hope, PABuilt 1977 · S/N 28-7816119N47676Wulfekuhler Louis E · Lansing, MIBuilt 1977 · S/N 28-7890113N4767DFulton Daniel M · Blacksburg, SCBuilt 1958 · S/N 34867N4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORBuilt 1979 · S/N 18267350N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091N47680New Mexico Flying Eagle DBA · Tucson, AZBuilt 1977 · S/N 28R-7737173N47687Acevedo Gabriel Jr · Rego Park, NYBuilt 1977 · S/N 28-7816120N4768BEversole Eric L · Kent, WABuilt 1955 · S/N 31666N4768DBoyd Amy L · Kila, MTBuilt 1958 · S/N 34868N4768EEagle Aviation Inc · Tucson, AZBuilt 1978 · S/N 17271633N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768NTreadwell Dennis A · El Cajon, CABuilt 1979 · S/N 18267351N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4768SDidier Thomas · Port Washington, WIBuilt 1969 · S/N 32-1176N47693Denton Max L · Marion, OHBuilt 1977 · S/N 28-7890118N47694Aircraft Owners And Pilots Assn · Frederick, MDBuilt 1977 · S/N 28-7890119N47697Andrews Dana C · Granite Bay, CAS/N 327840012N47698Mcgregor Daniel A · Denali Park, AKBuilt 1968 · S/N 31-153N47699Swinney Audie G · Henryetta, OKBuilt 1977 · S/N 28-7816123N4769ANewbury Terry A · Florence, ALBuilt 1956 · S/N 22-3917N4769BNesbett David A Trustee · Anchorage, AKBuilt 1955 · S/N 31667N4769GMagnumforamen Ppg Aero Adventures LLC · Kalispell, MTBuilt 2002 · S/N 5699N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N4769LTurn 2 Aviation LLC · Bloomsburg, PABuilt 1967 · S/N 28-4101N4769NTurner Luke · Mineral Wells, TXBuilt 1979 · S/N 18267352N4769SRedemption Leasing LLC · Kodiak, AKS/N 32-1177
Back to AD 2007-04-19 R1