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.

N4467RBrackett David E · Line Lexington, PABuilt 1974 · S/N 17263209N4467SK & M Leasing Inc · Camden, ARBuilt 1975 · S/N E-694N4467YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4119N44682Weatherbie Karen S · Centennial, COBuilt 1974 · S/N 28-7425437N44686Boca Flying Club Inc · Boynton Beach, FLBuilt 1974 · S/N 28-7515004N4468JCentral Arkansas Flying Club Inc · Bryant, ARS/N 28-22884N4468RSchmitt Dillon Allen · Caledonia, MIBuilt 1974 · S/N 17263210N4468SKyle Robert K · Madison, MSBuilt 1975 · S/N E-696N4468TSpitzer Helicopter LLC · Wilmington, DEBuilt 2010 · S/N 4447N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N4468YBegrow Adroaldo Dorivaldo · Gulf Shores, ALBuilt 1966 · S/N 25-4120N44690H&M Air LLC · Metamora, MIBuilt 1974 · S/N 28-7515006N44691One Zero Charlie Aviation LLC · Cary, ILBuilt 1974 · S/N 28-7405275N44696Elliot Jerry B · Mount Pleasant, MIBuilt 1974 · S/N 28-7410108N44697Viets Bret A · Buffalo, MOBuilt 1974 · S/N 28-7410109N4469AStacy Richard E · Westfield, NYBuilt 1956 · S/N 22-3802N4469WDietle Kurt D · Valley Springs, CABuilt 1974 · S/N CE-494N446ACRegistered aircraftBuilt 2000 · S/N 446-2000N446ALValiair Lc Trustee · Casper, WYS/N CE-1137N446ASFreeman Tim B · Haymarket, VAFirst renewal noticeBuilt 1977 · S/N 32R-7780464N446BBJb Buffalo LLC · Frisco, TXBuilt 2025 · S/N 14827N446BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 4496553N446BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496600N446CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13263N446CSSocal Pilot Center · La Quinta, CABuilt 2017 · S/N 172S12001N446DCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 40.446N446DSFun Air LLC · Houston, TXBuilt 2002 · S/N 40.246N446ERWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10220N446GWPrati Paul B · El Paso, TXBuilt 1978 · S/N 3N446HSUS Department Of Agriculture · College Station, TXBuilt 2012 · S/N 13313N446JRSpangler John T · Mount Pleasant, PABuilt 1974 · S/N CE-541N446KWClementi Frank R · Wesley Chapel, FLBuilt 2011 · S/N 1474RN446MKNorth Star Aviation · Mankato, MNBuilt 2018 · S/N 4496448N446MMInternational Air Services Inc Trustee · Carson City, NVS/N 4608006N446PAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496086N446PCStatius-Muller Robert C Trustee · Stamford, CTBuilt 2006 · S/N 29-0446N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474N446RMRocky Mountain College · Billings, MTBuilt 2023 · S/N 28020111N446SPLam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 172S8310N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164N446TCChena River Aviation Inc · Fairbanks, AKBuilt 2023 · S/N 14638N446TTC5 Aviation LLC · Sheridan, WYBuilt 1974 · S/N 28R-7435317N446YBBeal James M Trustee · Eugene, ORBuilt 2012 · S/N 91919N44702Shawback Brian D · Anchorage, AKBuilt 1974 · S/N 28-7515007N44704Bender Aviation Services Inc · Clearwater, FLBuilt 1974 · S/N 28-7515008N44705Warden James L · West Milford, NJBuilt 1974 · S/N 28-7515010N44708Interthal Mike · Butler, PABuilt 1974 · S/N 28-7405277N4470AAnderson Stephen A · Yuba City, CABuilt 1956 · S/N 18-4822N4470JBister John C · Culver, ORBuilt 1967 · S/N 28-22886N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778
Back to AD 2007-04-19 R1