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.

N35MXMontanez George O · Mesa, AZBuilt 1960 · S/N D-6411N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193N35PHTsi Holdco Inc · Virginia Beach, VABuilt 1984 · S/N 1981-AN35QTReady Aim Flyer LLC · New Castle, DES/N D-8839N35RBBarnes Roger A · Cheyenne, WYBuilt 1963 · S/N D-7219N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930N35RKKropp Richard G · North Creek, NYBuilt 2025 · S/N 70756N35RSSudderth Robert W · Holly Lake Ranch, TXBuilt 1994 · S/N 1785LN35RXRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 496-79N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442N35SHSmith Floyd D · Centralia, WABuilt 1982 · S/N KUBINSKI-0001N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TCLynn David R · Mobile, ALBuilt 1964 · S/N CD-776N35TEOusley James Dean Jr · Granbury, TXBuilt 1979 · S/N E-1550N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812N35TXBauries Brian W · Abilene, TXBuilt 1994 · S/N 19020CN35UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N D-6795N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35VEMckibben Howard Stephens · Elk Grove, CABuilt 1961 · S/N D-6694N35VHBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 18268129N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247N35VZAlons Kevin D · Salix, IAS/N DMO 291N35WCHawley Flying Club Inc · Fargo, NDBuilt 1979 · S/N 28-8016180N35WD4lo Air & Land LLC · Damascus, ORS/N 2050234N35XFCaudle David William · Arlington, TXBuilt 1958 · S/N D-5674N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321N35XTWrench John D · Los Olivos, CABuilt 1978 · S/N 18266390N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N35YTArmstrong Samuel V · Lovelock, NVBuilt 1955 · S/N D4058N35ZFlood Joseph W · Franklinville, NJBuilt 1987 · S/N 0Z-7N35ZQZq Navigation LLC · Bellingham, WABuilt 2023 · S/N 18283244N36008Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 268-73N3600PPaul Mike · Sprague, WABuilt 1955 · S/N 22-3321N3600RArapahoe Flight Club LLC · Colorado Springs, COBuilt 1969 · S/N 28-5706N3600URiera Jose Gregorio · Saint Augustine, FLBuilt 1963 · S/N 18255000N3600ZDay Charles W · Sedan, KSS/N 22-7488N36010Eskildsen Chris A · Connell, WAS/N 535-73N36011Titus Larry E · Springview, NEBuilt 1973 · S/N 536-73N36013Jones Joseph D · Broken Arrow, OKBuilt 1973 · S/N 98-73N3601CLloyd Land Plane IV LLC · Brighton, COBuilt 1954 · S/N 31099N3601ELsn Air LLC · Morrison, COBuilt 1978 · S/N 17271603N3601PCox Jay D · Perryton, TXBuilt 1955 · S/N 22-3323N3601QWard Harry W Trustee · Williamsburg, VABuilt 1967 · S/N MA-226N3601WPrecision Landings Inc · Wilmington, DEBuilt 1966 · S/N 32-498N3601XHarrell Joshua Thomas · Forsyth, GABuilt 1968 · S/N 298
Back to AD 2007-04-19 R1