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.

N26896Magnus Air Ct LLC · Manchester, CTBuilt 1978 · S/N AA5A0751N26899Gibson Daniel W · San Marcos, TXBuilt 1979 · S/N AA5A0796N2689CColvin Clu DBA · Big Cabin, OKS/N 35089N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497TN2689QKirschke John K · Seneca Falls, NYBuilt 1966 · S/N 18257889N2689RMortensen Mark S · Hamilton, MTBuilt 1967 · S/N 18258389N2689WLocke Timothy S · Fort Irwin, CABuilt 1966 · S/N 1006N268AFApogee Flight Inc · Bellingham, WABuilt 1961 · S/N G-828N268BGHuff Holdings LLC · Ashland, KYBuilt 1976 · S/N 28-7690268N268BHJett Cory L · Floyds Knobs, INS/N 888-76N268CDKahng Jim · Torrance, CABuilt 2003 · S/N 0436N268CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283018N268CRMaxcy Christopher L · Bozeman, MTBuilt 2010 · S/N 4N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258N268DASpartan Education LLC · Tulsa, OKBuilt 2002 · S/N 4496135N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570N268DMRobinson Michael E · Chandler, AZBuilt 2005 · S/N 170N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268N268JCShaw Melvin · Annapolis, MDBuilt 1978 · S/N R18200213N268JGSpero Bruce A · Carson City, NVS/N 4N268MAMasters Of The Air LLC · Salt Lake City, UTBuilt 1975 · S/N 28-7515338N268MCRegistered aircraftBuilt 2025 · S/N 22002N268MERegistered aircraftBuilt 2000 · S/N 18280776N268MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881366N268PBeaulot LLC · East Aurora, NYBuilt 2006 · S/N E-3750N268RKalhart Transportation Services Inc · Rancho Santa Fe, CABuilt 1977 · S/N E1092N268RJHudson David A · Jonesboro, ARBuilt 2010 · S/N 001N268RVRegistered aircraftBuilt 2006 · S/N 81313N268SStrohmeyer Charles R II · Lancaster, OHBuilt 2002 · S/N 80682N268SAInarayan Inc · Winter Park, FLBuilt 1963 · S/N TC-554N268TZHague Robert A · Rogers, ARBuilt 2020 · S/N 18283108N268YMilton Quincy N · Bellevue, WABuilt 1959 · S/N 35846N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947N26907Registered aircraftBuilt 1979 · S/N AA5A0804N2690AHamons Jeffery W · Perrysburg, OHBuilt 1978 · S/N E-1264N2690CEdwards Zachary · Sylmar, CABuilt 1978 · S/N R18200214N2690FStephenson Casey H · Assaria, KSBuilt 1965 · S/N 18256790N2690GFerkin Air LLC · Caldwell, IDBuilt 1959 · S/N 51990N2690JDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N T18803498TN2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104N2690RSchleck Scott A · West Concord, MNBuilt 1967 · S/N 18258390N2690TN633at LLC · Punta Gorda, FLS/N 414A0408N2690YSmith Joshua B · Kenai, AKS/N 18051190N26913Alto Vista Flying Club · Cupertino, CABuilt 1979 · S/N AA5A0808N26915Doolittle Dean M · Bandera, TXBuilt 1979 · S/N AA5A0809N26917Nebrig Kenneth J Trustee · Prescott, AZBuilt 1979 · S/N AA5A0812
Back to AD 2007-04-19 R1