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.

N4200YTexas Red Bird LLC · Palo Pinto, TXBuilt 1977 · S/N 964-77N42016Roush Everett Wayne · Forsyth, GAS/N 18258810N4201BNrnc LLC · Camden, DEBuilt 1975 · S/N 75-30775N4201CFlying 4 LLC · Whiteville, TNBuilt 1974 · S/N 414-0517N4201HWattenbarger Jay K · Fairbanks, AKS/N 14-4N4201JYoerg Keith W · Culver City, CAS/N 28-22545N4201LSuverkrup Mark · Columbus, INBuilt 1978 · S/N 24-0572N4201QReeve Ryan · Hurricane, UTBuilt 1971 · S/N 17260101N4201UEclipse Air LLC · Versailles, MOBuilt 1978 · S/N 24-0574N4201XWilson Daniel L · Sparta, MIS/N 5201N4201ZBennett Ruth B Trustee · Vancouver, WABuilt 1966 · S/N 18-8420N42020Brewster Matthew L · Chico, CABuilt 1968 · S/N 18258812N42024White Wings Air Inc · Jacksonville, FLBuilt 1974 · S/N 17264153N42025Stokes Clive V · Gilbert, AZBuilt 1972 · S/N 18052301N42026Bains Jordan John W · Anchorage, AKBuilt 1972 · S/N 18052302N42027Dehart Dee Y · Payson, UTBuilt 1968 · S/N 18258818N4202JParker Aviation LLC · Camdenton, MOBuilt 1966 · S/N 28-22546N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747N4202PWells John · Eugene, ORBuilt 1959 · S/N 23-1691N4202QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260102N4202TSexton Ronnie K · Clarksville, ARBuilt 1971 · S/N 28-7205090N4202XIzzy Air LLC · Madison, WIBuilt 1971 · S/N 5202N4202YAll Sports Aviation LLC · Cocolalla, IDBuilt 1977 · S/N 603-77N4202ZPiatt Matthew D · Wasilla, AKBuilt 1966 · S/N 18-8421N42033State Of Alaska · Anchorage, AKBuilt 1974 · S/N 17264154N42035Paulsen Hans J · Cedartown, GABuilt 1974 · S/N 17264155N42036Murphy Steven R · Aguila, AZBuilt 1968 · S/N 18258822N4203ABas Part Sales LLC · Greeley, COBuilt 1970 · S/N TH-22N4203HIvy Mark A · Anchorage, AKBuilt 1948 · S/N 14-6N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748N4203QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260103N4203SWright John D · Richmond, TXBuilt 1976 · S/N E-958N4203XNaples LLC · Mound City, MOBuilt 2008 · S/N 12619N4203ZLongboat Key Aviation LLC · Wooster, OHBuilt 1966 · S/N 18-8422N42041Armenia John Robert · Land O Lakes, FLBuilt 1968 · S/N 18258825N42042N1622f LLC · Grand Prairie, TXS/N 18258826N42044Van Beusekom Brian T · Loretto, MNBuilt 1968 · S/N 18258828N42045Jones Daryn W Trustee · Sumpter, ORBuilt 1968 · S/N 18258829N42049King Ronald E · Englewood, FLBuilt 1968 · S/N 18258830N4204BLieske William R · Lonsdale, MNBuilt 1974 · S/N 75-30753N4204HAndrews Billy G · Wasilla, AKS/N 14-7N4204TMorin Lucien A · San Antonio, TXBuilt 1971 · S/N 28-7210004N4204WWilbourne Danny L · Melbourne, FLBuilt 2008 · S/N 1970N4204XAircraft Equipment Storage LLC · Duson, LABuilt 2009 · S/N 12625N4204YCharles Tim W · Caldwell, IDBuilt 1977 · S/N 293-77N4204ZKansas Air LLC · Linn, KSS/N 18-8423N42050Baum Thomas J · Kaufman, TXBuilt 1969 · S/N 27-4081N42051Flying M Aviation Inc · Irondale, ALBuilt 1972 · S/N 18052305N42053Jewett Clinton Baxter Trustee · Colusa, CABuilt 1968 · S/N 18258832N42055Klp Aeromotive LLC · Morriston, FLBuilt 1973 · S/N 18052306
Back to AD 2007-04-19 R1