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.

N54474Westerfield Aviation LLC · Hopkinsville, KYBuilt 1973 · S/N 28-7410046N54477Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17274983N54478Lavi Nir · Burlington, MAS/N 28-7425142N54479Two2fly Aviation LLC · League City, TXBuilt 1973 · S/N 28-7425144N5447ASchmidt Aaron B · Auburn, ALBuilt 1985 · S/N P21000855N5447DN5447d LLC · Seminole, OKS/N D-5001N5447FMyers Jeff W · De Leon Springs, FLBuilt 1976 · S/N 28-7715140N5447KFly For Fun LLC · Frederick, MDBuilt 1980 · S/N 17274114N5447TWalkington Noel John · Pittsburgh, PABuilt 1982 · S/N R18201868N5447UFly Boston Bailey LLC · Gilbert, AZBuilt 1967 · S/N CE-162N5447ZAnderson Zane M · Maumelle, ARBuilt 1962 · S/N 18-7842N54485Schrock Paul · Mooresville, NCBuilt 1973 · S/N 28R-7435112N5448BDesjardins Norman W · Gresham, ORBuilt 1956 · S/N 33448N5448FSanford Christopher Evan · Dallas, TXBuilt 1976 · S/N 28-7790124N5448NRadial Enterprises LLC · New Carlisle, OHBuilt 1980 · S/N 18267722N5448PStarfire Aviation LLC · Conyers, GABuilt 1958 · S/N 24-503N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001N5449DDavis Roger T · Lakeland, FLBuilt 1957 · S/N D-4935N5449FEngel Rodney · New Prague, MNBuilt 1976 · S/N 28-7790125N5449HMoorhead Aviation Services LLC · Moorhead, MNBuilt 1975 · S/N 17265445N5449LSkycat Aviation LLC · Asheville, NCBuilt 1974 · S/N AA5-0649N5449WBlue Skies Aviation Inc · Lowville, NYBuilt 1962 · S/N 28-527N544AAFriedemann Jon · Manzanita, ORBuilt 2007 · S/N 25572N544AB544ab Aircraft Leasing LLC · Spanish Fork, UTBuilt 2003 · S/N 10048N544AKMace Tory · Wilmington, DEBuilt 2010 · S/N 12924N544ARAircraft Registration Inc Trustee · KematenBuilt 1999 · S/N 0025N544ATArmstrong Helicopters LLC · Laredo, TXBuilt 2006 · S/N 11397N544BBVeracity Aviation LLC · Seguin, TXBuilt 2007 · S/N 11592N544BPLopez Federico Ruiz · Hollywood, FLS/N 34-7250344N544CAJet Air Inc · Iowa City, IABuilt 1974 · S/N 28-7415206N544CBCbhelos LLC · Chesapeake, VABuilt 2008 · S/N 12519N544CDAeroplanes LLC · Cary, NCBuilt 2005 · S/N 1544N544CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881053N544DADawson Aircraft Inc · Clinton, ARBuilt 2019 · S/N 100N544DCAqx Solar LLC · Bennington, VTBuilt 2015 · S/N 83391N544DJSouthern Ohio Aviation LLC · Lake Waynoka, OHBuilt 1973 · S/N 28-7415060N544DLMcwilliams Richard L · Santa Paula, CABuilt 2005 · S/N 10783N544DRKaranan Corp · Sarasota, FLBuilt 1977 · S/N AA5B-0542N544EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13318N544FAQuality Helicopter Leasing LLC · Gardena, CABuilt 2016 · S/N 13991N544GL In The Sky LLC · Horseshoe Bay, TXBuilt 2011 · S/N E-3947N544HLrh Equipment LLC · Pendleton, ORS/N 335N544JHJosub LLC · Greenville, NCFirst renewal noticeBuilt 2016 · S/N 13962N544KSKent State University · Stow, OHBuilt 2026 · S/N 172S13510N544MTrim Tab LLC · Fort Collins, COS/N CE-104N544MHHood Helicopters LLC · Longwood, FLBuilt 2000 · S/N 0739N544NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010013N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981N544RAnderson Daniel R · Venus, TXBuilt 1960 · S/N 39210N544RCPortfolio 544rc LLC · Wilmington, DEBuilt 2013 · S/N 13431
Back to AD 2007-04-19 R1