AD 80-25-07 R1

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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.

N711UATuthill Andrew M · Etna, NHBuilt 1978 · S/N 17271695N711WEMelbourne Flight Training LLC · Melbourne, FLS/N 17272616N711ZHappenstance LLC · Cabot, ARBuilt 1976 · S/N 177RG0959N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420N7120VOpulent Investments LLC · Mandan, NDBuilt 1974 · S/N 21-0043N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822N7122VProvance Brent L · Granbury, TXBuilt 1974 · S/N 22-0051N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124UGoss Brendan · Shady Shores, TXS/N 363N7124VHunter Cameron Brooks · Keller, TXBuilt 1974 · S/N 22-0053N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125UTakacs Robert S · Oxford, CTBuilt 1964 · S/N 364N7125VSutphen James A · Henderson, TXBuilt 1974 · S/N 22-0054N7127VChenal Robert B · Pawcatuck, CTBuilt 1974 · S/N 22-0056N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128VLinville Aero LLC · Chapel Hill, NCBuilt 1974 · S/N 22-0057N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712KWing John David · Guymon, OKS/N 389-78N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N7130VKerkstra Hilary · Portage, MIBuilt 1974 · S/N 22-0059N7131SMaya Aircraft Holdings LLC · Lee, NHBuilt 1981 · S/N R18201697N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N7132VCrowley Preston R · Northport, ALBuilt 1974 · S/N 20-0033N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7133VKing Mitchell Earl · Columbus, MSBuilt 1974 · S/N 20-0034N7134UDalton James D · Pasadena, TXBuilt 1964 · S/N 373N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435N7135VHerkoltz Patrick Alan · Phelan, CABuilt 1974 · S/N 20-0036N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436N7136VHickman Jared · Bothell, WABuilt 1974 · S/N 21-0045N7136XArchangel Michael Flyers Inc · Princeville, HIS/N 17702290N7137UMalone David V · Oklahoma City, OKBuilt 1964 · S/N 376N7137VZelek Daniel · Wurtsboro, NYBuilt 1974 · S/N 21-0046N7138UHinkle Robert J · Caldwell, IDBuilt 1964 · S/N 377N7138VColombo Brian M · Oswego, NYBuilt 1974 · S/N 21-0047N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439N7139TPhilpot John Michael · Liberty, MOS/N R18200025N7139UMott Charles A Jr · Chesapeake, VAS/N 378N713BMMathieu Robert B · Delhi, LABuilt 1980 · S/N R18201453N713JADesert Sealants Corp · Queen Creek, AZBuilt 1984 · S/N 24-1434N713JKSbarounis Carl A · Torrance, CABuilt 1975 · S/N 17265460N713JPArizona Technical Construction LLC · Lake Havasu City, AZBuilt 1966 · S/N 3313
Back to AD 80-25-07 R1