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.

N32056Steuer Christopher · Plumas Lake, CABuilt 1974 · S/N 28-7515056N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021N3205BDurben Robert W · Newcomerstown, OHBuilt 1953 · S/N 22-2032N3205DWest James · Monroe, MIS/N 32003N3205FHawkins William J II · Saint Petersburg, FLS/N 680002N3205JSchumacher Eraine · Hague, NDBuilt 1958 · S/N 1238N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605N3205VGonzalez Efrain · Manhattan Beach, CABuilt 1994 · S/N E-2899N32066Chadwick Cobb Kristy L · Tallahassee, FLBuilt 1974 · S/N 28-7515059N32067Legeros David · Brooklyn, NYS/N 28-7515060N32068Christensen Gary L · Royal City, WABuilt 1974 · S/N 28-7515061N32069Adb Investments LLC · Duncan, SCBuilt 1974 · S/N 28-7515062N3206DDenny Michelle L · Chugiak, AKBuilt 1955 · S/N 32004N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467N3206JHopman Pablo I · Stow, MABuilt 1994 · S/N EA-568N3206LAlpha Tango LLC · Omaha, NEBuilt 1976 · S/N D-9951N3206MHme Aviation LLC · Mount Pleasant, SCS/N 12041N3206SHall David J · Red Bluff, CABuilt 1964 · S/N 18255706N3206YN3206y Aviation LLC · Bloomfield Hills, MIBuilt 1994 · S/N E-2903N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468N3207FGoodwin Winston L · Cypress, TXBuilt 1967 · S/N 670361N3207LRdl Construction Inc · Hollister, CABuilt 1976 · S/N E-935N3207PTraverse Air Inc · Traverse City, MIBuilt 1957 · S/N 23-1147N3207RLingerfelt Joseph A · Woodburn, ORBuilt 1969 · S/N 28R-31129N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607N3207WZero Seven Whiskey LLC · Norco, CABuilt 1965 · S/N 32-7N320827550g LLC · Birmingham, MIBuilt 1974 · S/N 28-7515065N32089Vosberg Jeffrey A · Norwalk, IABuilt 1974 · S/N 28-7510012N3208AKreitel Cody James · Anchorage, AKBuilt 1953 · S/N 25852N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021N32097Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 28-7515067N32099Odland Steve E · Luverne, MNBuilt 1974 · S/N 28-7515068N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735N3209JDennis John W · Mooresville, NCBuilt 2000 · S/N E-3299N3209PMg Renewal Corp Inc · Salt Lake City, UTFirst renewal noticeBuilt 1957 · S/N 23-1150N320AGBusenbark Kenneth A · Niceville, FLBuilt 1991 · S/N 37032012614P2N320AJDaedalus Wings Inc · Malvern, OHBuilt 2011 · S/N 77FBN320AKMclauchlin Todd · Sparks, NVBuilt 2001 · S/N 3841N320AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496496N320BFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1957 · S/N D-5170N320BDDavis Burton D · Jefferson, IABuilt 2023 · S/N 906-320-747N320BMSchenk Jonathan M · Amarillo, TXFirst renewal noticeBuilt 2019 · S/N 96MN320BSPriewe Steve R · Sardis, MSBuilt 2001 · S/N 357-320-115N320BVLaird Brian N · Monument, COBuilt 2005 · S/N 1N320BWWinterberg Brian D · Garberville, CABuilt 1997 · S/N 770-320-612FB
Back to AD 2007-04-19 R1