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.

N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511N5297TMid Atlantic Air Museum · Reading, PABuilt 1972 · S/N 34-7250245N5297WTausch Eddie W · Port Aransas, TXS/N 28-348N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022N52981J-Bear Aviation LLC · Whitefish, MTBuilt 1974 · S/N 18262984N52983Cabaud John P · Oroville, CABuilt 1974 · S/N 18262986N52989Southwest Tailwinds LLC · Camarillo, CABuilt 1974 · S/N 18262989N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500N5298EDunlap Russell M · Palmer, AKBuilt 1959 · S/N 50598N5298GDmgf LLC · Bertram, TXBuilt 1951 · S/N 22529N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051N5298NJ3m Airops LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9244N5298PCroasdale Terry Lee · Modesto, CAS/N 24-339N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512N5298SSix Ten Ventures LLC · Grand Prairie, TXBuilt 2002 · S/N 172S9246N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396N5298UPatanapong Somboonsap · Oakland Park, FLBuilt 1964 · S/N U2060298N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349N52992Registered aircraftBuilt 1974 · S/N 18262991N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654N52994Carpenter Michael · Hardin, MOBuilt 1974 · S/N 18262993N52996Mcnab Michael J Trustee · Slayton, MNBuilt 1974 · S/N 18262994N52997Plaugher Carl L · Cocoa Beach, FLBuilt 1974 · S/N 18262995N52998Frauenhoff Frank W · Manhattan, NVBuilt 1974 · S/N 18262996N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501N5299ERosenberg Douglas S · Tillamook, ORBuilt 1983 · S/N 18268308N5299GSoloway Gary F · Lebanon, TNS/N 22111N5299LSerafini Ronald S · Murphy, NCS/N 28-4601N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603N529AJCaiazzo Leonard · Belle Harbor, NYBuilt 2004 · S/N 1242N529CANeufeld Don I · Fairview, OKS/N 17269104N529CCC747 LLC · Wilmington, DEBuilt 1969 · S/N TC-1230N529CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 1621N529CMHill Thomas Gerald · Port Tobacco, MDBuilt 2010 · S/N 40700N529CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843925N529DARegistration Pending · Travis Afb, CARegistration pendingBuilt 2020 · S/N 2881423N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151N529ERPs N529er LLC · Green Bay, WIBuilt 2002 · S/N 172S9111N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042N529JAAnton Aaron · Poplar Grove, ILBuilt 1965 · S/N TD-617N529JKSkydogs LLC · Fairfax, VABuilt 1977 · S/N 18265525N529JSNorthgate Enterprises LLC · Anchorage, AKBuilt 2005 · S/N 81846N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970N529LHRightway Drywall Inc · Macon, GABuilt 2019 · S/N TH-2517N529LJRad Equipment Leasing Inc · Austin, TXBuilt 2004 · S/N 40.436
Back to AD 2007-04-19 R1