OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613N121MEEvergreen Empire LLC · Delano, CABuilt 2007 · S/N 11797N121MNNielsen Mark C · Green Bay, WIBuilt 1997 · S/N MN-01N121MSDarcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 17271893N121PAN121pa LLC · Kalispell, MTBuilt 2019 · S/N 32-0010N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388N121PGGinter Jon A · Marlton, NJBuilt 2005 · S/N 70731N121PRPaulich John III · Naples, FLBuilt 2005 · S/N 71295N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660N121RDVickery Forest H · Tallahassee, FLS/N 18052053N121RFRafamedia LLC · Stamford, CTBuilt 1976 · S/N 13048N121RHHelirod LLC · Oro Valley, AZBuilt 2023 · S/N 14615N121RJCessna 121 Rj LLC · Terra Bella, CABuilt 1972 · S/N 21059735N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072N121RPJohn A Rossi Inc · West Chester, PABuilt 1998 · S/N 29-0141N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N121SXRegistered aircraftBuilt 2018 · S/N 14147N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105N121TVSky Helicopters Inc · Eustace, TXBuilt 2012 · S/N 13214N121UCEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280420N121VAAerodynamic LLC · Aurora, ORBuilt 2021 · S/N 1034N121VKOcala Aviation Services Inc · Ocala, FLBuilt 1984 · S/N 17276101N121VTWilliams Ralph J · Essex Junction, VTBuilt 2007 · S/N 99-1131N121VUThomason Stewart A · Charleston, SCBuilt 1991 · S/N 10057N121WN121w LLC · Union Gap, WABuilt 2019 · S/N 172S12276N121WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12322N121WMBarnes Robert B · Chico, CABuilt 1980 · S/N 638-80N121WPRoy Frank W · Millinocket, MES/N 1382N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272N12208Shepard John A · Thornville, OHBuilt 1972 · S/N 300-72N12209Melendez Jesus · North Miami, FLS/N 17261881N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232N1220HScroggs Jack F · Anchorage, AKBuilt 1948 · S/N 15AC-232N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246N1220RKeywestaero LLC · Wilmington, DEBuilt 2005 · S/N 18281582N1220UParinger Glenn R · Nashotah, WIBuilt 1993 · S/N 0092N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800N12210Exclusive Motors Inc · Grand Prairie, TXBuilt 1973 · S/N 17261882N12211Miller Todd B · Wayne, ILBuilt 1973 · S/N 17261883
Back to AD 2007-04-19 R1