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.

N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423CAAerochatt LLC · Cleveland, TNBuilt 2015 · S/N 172S11612N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109N423CFMiller Lyndon J · Georgetown, TXBuilt 2008 · S/N 001N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394N423CMHurricane Creek Flying Club LLC · Walla Walla, WABuilt 2000 · S/N 20608109N423CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496439N423CZRutan Aircraft Flying Experience · Waller, TXS/N 423N423DKOliveira Avelino Da Mota · Aventura, FLBuilt 1981 · S/N R18201809N423DMGga N423dm LLC · Glendale, AZBuilt 1969 · S/N 28-25683N423EWings Over Texas Holdings LLC · Denton, TXBuilt 2014 · S/N 172S11447N423FLIglewski David W · Muskego, WIBuilt 1971 · S/N 28-7125204N423FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC023N423JAGiegler Bernard · Cypress, TXBuilt 2002 · S/N 60241N423JCPeterson Daniel R · Riverview, FLBuilt 1967 · S/N 28-3922N423JDAlbert Hall Co LLC · Shreveport, LABuilt 2004 · S/N 1179N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951N423JWSkeens Gregory Jr · Encinitas, CAS/N 32-7840163N423LCYabsley Richard A · Santa Barbara, CABuilt 2017 · S/N 517RN423LL79bravo Leasing LLC · Lincoln, DEBuilt 1975 · S/N 18264071N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439N423PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843463N423PMMen Aviation LLC · Foristell, MOBuilt 2008 · S/N 12211N423PWBeggs Pat · Salem, ORBuilt 2018 · S/N CC19-0039N423RElint Technology Inc · Gulf Breeze, FLBuilt 1981 · S/N 32R-8213023N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270N423RGSchue Gary C · Fredericksburg, VABuilt 2005 · S/N SES-181MB2N423RVIndy Air Sales LLC · Anderson, INBuilt 1991 · S/N 1023N423SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12542N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352N423TSandpoint Aviation LLC · Sandpoint, IDBuilt 2003 · S/N 43N423TABas Part Sales LLC · Greeley, COBuilt 2003 · S/N T18208208N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426N423YEconome James S · Danville, CABuilt 1961 · S/N D-6845N42400Smith Randolph L · Orovada, NVBuilt 1968 · S/N 18259004N4240142401 LLC · Hailey, IDBuilt 1973 · S/N 18052350N42404Millennium Airways LLC · Valencia, CABuilt 1974 · S/N 28-7415391N42409Ross Leslie W · Truckee, CAS/N 18259006N4240HSorensen Michael J · Mayer, MNBuilt 1948 · S/N 14-42N4240JBillings Christopher · St Johns, FLBuilt 1967 · S/N 28-22593N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140N4240TBlankenbijl Eric J · Grapeview, WAS/N 28-7205112N4240XMaule Group LLC · Danbury, CTBuilt 1999 · S/N 30004CN4240ZLoomer Orville C · Buffalo, WYS/N 18-8467N42415Barron Texas Holdings LLC · Sheridan, WYS/N EPC-162N4241BBor-It Mfg Co Inc · Ashland, OHBuilt 1974 · S/N 75-30727N4241JImmen David F · Bonanza, ORBuilt 1967 · S/N 28-22594N42421Registered aircraftBuilt 1968 · S/N 18259011N42424Bowyer Charles W Stephen · Tucson, AZBuilt 1968 · S/N 18259013
Back to AD 2007-04-19 R1