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.

N3296PMadlener Michael J · Pahrump, NVBuilt 1996 · S/N ES-003N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103N3297FCadillac Aircraft Services Inc · Cadillac, MIBuilt 1967 · S/N 670390N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598N32990Pray Aviation Inc · Augusta, KSBuilt 1974 · S/N 28-7515285N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699N3299WLowe Russell · Navarre, FLS/N 32-133N329ABDm Aviation Services LLC · Kennebunk, MEBuilt 2004 · S/N 10578N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000N329BCHerring Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2006 · S/N 40190N329CBullard Aviation Services Inc · Ormond Beach, FLBuilt 1973 · S/N CE-444N329DPHitchcock Aviation LLC · Twin Falls, IDS/N 18-7609149N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991N329FPNetwork Spares · Wilmington, DEBuilt 1969 · S/N 18-7421N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45N329HPRight Rudder LLC · Halifax, PABuilt 2000 · S/N 3246166N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835N329JHAlliance Aircraft Sales Inc · Pierre, SDBuilt 1976 · S/N E-870N329JKEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10674N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512N329PWHarvey Robert C · Hortonville, WIBuilt 2010 · S/N 40729N329RPPettis Loren K · Thomaston, GABuilt 2002 · S/N 24828N329RTRegistered aircraftBuilt 1972 · S/N D-9343N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443N329TADelta Pacific Northwest LLC · Anchorage, AKBuilt 1968 · S/N 18-8699N329WPPhillips J Weston · West Jefferson, NCBuilt 2025 · S/N 18283329N329XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1964 · S/N D-7509N32ABJacobson Neal D · Baker City, ORBuilt 2013 · S/N 81962N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002
Back to AD 2007-04-19 R1