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.

N3585WRodriquez Nat III · Odessa, TXBuilt 1966 · S/N 32-479N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777N3587FStout Colt W · Bosque Farms, NMBuilt 1966 · S/N 18257587N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543N3588UBattles Danny C · Burns Flat, OKBuilt 1963 · S/N 18254988N3589Sale Reported · Lonoke, ARSale reported, pending cancellationBuilt 1970 · S/N 680N3589FInmon Glen A · Pontotoc, MSBuilt 1966 · S/N 18257589N3589KClark Joseph D · Kilgore, TXBuilt 1967 · S/N 28-23646N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689N3589WCfi Aero LLC · Riverside, CABuilt 1966 · S/N 32-484N3589YHmb Aviation LLC · St George, UTS/N 18254489N358ALlewellyn Development LLC · Charlotte, NCBuilt 1978 · S/N D-10163N358BWard Mike · Carnesville, GABuilt 1957 · S/N D-5013N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806N358BHKelley Zachary · Anchorage, AKBuilt 2019 · S/N 1028N358BTRorabaugh Kenneth P · Sunrise, FLS/N 32-40051N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283N358CBHurn Farm Enterprises LLC · Grand Beach, MIBuilt 2025 · S/N 18283314N358CDOptimal Aircraft Management Mi LLC · Sanford, MIBuilt 2004 · S/N 0967N358CFApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995115N358CMEathcirc 08 LLC · Tucson, AZBuilt 1989 · S/N TH-1546N358CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281510N358DGSky Equipment LLC · Salem, WIBuilt 2015 · S/N 13821N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428N358JCDuran Peter F · Mesa, AZBuilt 1993 · S/N 058BN358MMatuska Douglas G · Kent, WABuilt 1999 · S/N 20913N358MERibelin Holdings LLC · Yacolt, WABuilt 2000 · S/N 18280847N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524N358QO'Quinn Shannon L · Ridgeland, SCBuilt 2023 · S/N 42146N358RMMrm Phoenix Ltd · Cape Girardeau, MOBuilt 2015 · S/N TH-2434N358RVDerby Kevin R · Clearwater, FLBuilt 1998 · S/N 22173N358RWHawley Elizabeth B · Wichita Falls, TXBuilt 1979 · S/N AA5B1066N358SBolla Bruce B · San Francisco, CABuilt 1967 · S/N D-8671N358SANelson Robert M Jr · Plano, TXBuilt 1998 · S/N E-3192N358SPIscovich Angel L · Santa Barbara, CABuilt 1997 · S/N 22468N358TBSlezak David · Davison, MIBuilt 1995 · S/N 1716N358TCEclipse Air Works LLC · Harker Heights, TXS/N TC2398N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858N358TWTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 172S9751N358VAChapman James H · Mebane, NCBuilt 2013 · S/N 25218N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417
Back to AD 2007-04-19 R1