OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N4774HBillstrand Thomas A · Memphis, TNBuilt 1979 · S/N 24-0867N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305N4774PCannan Aviation Inc · Georgetown, TXBuilt 1980 · S/N 15284813N4775DHetrick-Price Willow · Anchorage, AKBuilt 1979 · S/N 17272357N4775HMile 13 Airplane LLC · West Hartford, CTBuilt 1979 · S/N 24-0868N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306N4775PRegistered aircraftBuilt 1975 · S/N 20675N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762N4777HMorey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283978N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764N477ALSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 17701285N477FReu Aviation LLC · Columbia, SCS/N 17265266N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645N4780RR&R Flight Services Inc · Mendota, ILBuilt 1975 · S/N 18802319N4781QStocker Russell · Woodland, CAS/N 18802523N4781TContinental Title Trust LLC Trustee · Wichita, KSS/N 170-75N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030N4783KLandwehr Wayne A · Gill, COBuilt 1979 · S/N P21000314N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633N4785SSchiller Matt D · San Francisco, CABuilt 1979 · S/N R18201426N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651N4786HRaines Charles G · Camarillo, CABuilt 1979 · S/N 24-0876N4786KRl Aviation LLC · Washington, DCS/N P21000317N4786PAce High Aviation LLC · Long Beach, CAS/N 15284816N4786SMultiprop Ventures LLC · Danvers, MABuilt 1979 · S/N R18201427N4787ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271652N4787SClassic Image Auto LLC · Huntsville, ALS/N R18201428N4788DJb Aviation Flight School Inc · Wonder Lake, ILBuilt 1979 · S/N 17272359N4788ETiernan Jeffery P · Waddington, NYBuilt 1978 · S/N 17271653N4788PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P21000108N4788VM Fujii Inc · Costa Mesa, CABuilt 1980 · S/N 172RG0378N4789DStevens Dennis W · Mohave Valley, AZBuilt 1979 · S/N 17272360N4789EPhil Weber Investments LLC · San Diego, CABuilt 1978 · S/N 17271654N4789GCrossflot Aviation Inc · Shepherdstown, WVBuilt 1979 · S/N 17273343N4789HChambers Kenneth G Trustee · Los Gatos, CABuilt 1979 · S/N 24-0879N4789KVitatoe Industries Inc · Chillicothe, OHBuilt 1979 · S/N P21000320N478BKWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15281022
Back to AD 80-25-07 R1