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.

N5610SJager Rylan W · Indn Hbr Bch, FLBuilt 1966 · S/N D-8177N5610UAnderson Aviation LLC · Bulverde, TXBuilt 1969 · S/N 28-26540N56114Anderson Douglas · Queen Creek, AZS/N 28R-7335357N56115Schenck Christopher R · The Woodlands, TXBuilt 1973 · S/N 28R-7335358N56119Button Eric T · Austin, TXBuilt 1973 · S/N 28-7305532N5611JJr'S Auto Care Center Inc · Gualala, CABuilt 1974 · S/N 18263466N5611PWeyland Aviation Inc · Lewes, DEBuilt 1959 · S/N 24-679N5611QSale Reported · Star Prairie, WISale reportedBuilt 1965 · S/N 3004N5611SHenry Daniel · Paris, TXBuilt 1966 · S/N D-8150N56125Upstate Flying Club Inc · Marcy, NYBuilt 1973 · S/N 28-7305535N56126Moore Holdings LLC · Janesville, WIBuilt 1973 · S/N 28-7305536N56129Skurzynski James S · Santa Ana, CABuilt 1973 · S/N 28R-7335361N5612JNovember Aviation Corporation · Hobart, WABuilt 1974 · S/N 18263467N5612KUptime Electonics Inc · Whittier, CABuilt 1964 · S/N TC-604N5612PClarity Aviation LLC · Boise, IDBuilt 1959 · S/N 24-680N5612QSrm Aviation Group LLC · Bentonville, ARBuilt 1965 · S/N 662N56130Flying Aces Aero-Fleet Inc · Guyton, GABuilt 1973 · S/N 28R-7335362N56131Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 32-7300052N56134Buxton Richard L · Boise, IDBuilt 1973 · S/N 28-7325578N56136Weed Brian Jeffrey · Omaha, NEBuilt 1973 · S/N 28-7305538N5613JMorgan Edward A · Buchanan Dam, TXBuilt 1974 · S/N 18263468N5613LRed Rock Flyers LLC · Flagstaff, AZBuilt 1974 · S/N 0704N5613QLysek Eric M · Erie, COBuilt 1965 · S/N 3005N5613UAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1970 · S/N 28-26543N5613WHocking Terry G · Nashwauk, MNBuilt 1962 · S/N 28-753N56140Lets Fly Az LLC · Scottsdale, AZBuilt 1973 · S/N 28-7305539N56141Simmerer Stephen J · Allenton, MIBuilt 1973 · S/N 28R-7335364N56149Lets Fly LLC · Albemarle, NCBuilt 1973 · S/N 28-7325579N5614KSherwood George R · Burlington, KYBuilt 1964 · S/N D-7375N5614PShetty Balakrishna · Wesley Chapel, FLBuilt 1959 · S/N 24-682N5614QAltitude Aviation Services LLC · Mountain Home, IDS/N 663N5614RLedvina Jay K · Mechanicsburg, PABuilt 1989 · S/N CE-1414N5614SShaughnessy William · Rochester, MNBuilt 1966 · S/N CE-48N5614WColeman John H · Jackson, MIBuilt 1962 · S/N 28-754N56155Blackmon Ethan T · Hot Springs, ARS/N 32-7300053N56158Munyon William · Vineland, NJBuilt 1973 · S/N 28-7325583N5615KDennmark Air LLC · Dighton, KSBuilt 1964 · S/N D-7377N5615QKhan Awad A · Clearwater, FLBuilt 1965 · S/N 3103N5615SBradley A Eli Dental Corp · Encinitas, CABuilt 1966 · S/N CE-49N5615WH&H Aviation LLC · Lehi, UTBuilt 1963 · S/N 28-755N56160Thatcher Michael · Delaware, OHBuilt 1973 · S/N 28-7305543N56161Ohmart Jeffrey A · Wichita, KSBuilt 1973 · S/N 28-7305544N5616BCasey Joseph · Buffalo, WYBuilt 1956 · S/N 33616N5616EDhl Skyhawk Inc · Martinez, CABuilt 1978 · S/N 17271902N5616KDebonair 5616k LLC · Saco, MEBuilt 1964 · S/N CD-747N5616PKallenberger Ross A · Bakersfield, CABuilt 1959 · S/N 24-684N5616SVanel Clyde · Cambria Heights, NYS/N D-8158N5616YBigfoot Aviation LLC · Wilmington, DEBuilt 1965 · S/N 18-8287N5617Roberts Andrew J · Brunswick, MEBuilt 2007 · S/N 7090N5617BTruck Plus · Nampa, IDBuilt 1956 · S/N 33617
Back to AD 2007-04-19 R1