OpenAirDocs.org
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.

N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846N13558Seitz Dennis · Wausau, WIBuilt 1973 · S/N 17262847N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998N1355WBloch Matthew William · Marquette, MIS/N 2636N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1356FJprg Aviation Inc · Orlando, FLS/N 17272999N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027N13573Davis Flying Services LLC · Gaithersburg, MDBuilt 1973 · S/N 17262856N1357CSummit Concepts Inc · Wilmington, DES/N 17702710N1357UHarte Ryan D · Lone Star, TXBuilt 1976 · S/N 17267028N13586Oreilly Thomas P · Oscoda, MIBuilt 1973 · S/N 17262860N13587Nasairs Flying Club · Strongsville, OHBuilt 1973 · S/N 17262861N1358UWaddill Paula J · Puryear, TNBuilt 1976 · S/N 17267029N1358WDavis Charles S · Fairfield Bay, ARBuilt 1964 · S/N 2722N13590Habibelahian Hamid Reza · Jefferson, TXS/N 17262863N13593Absolute Altitude LLC · Murrieta, CABuilt 1973 · S/N 17262866N13594Chambers Quentin S · Bellingham, WABuilt 1973 · S/N 17262867N13596Gary Rollin F · Dallas, TXS/N 17702440N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711N1359UHokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 17267030N1359WKroll Richard · Laguna Niguel, CABuilt 1963 · S/N 2640N135DLOver And Under Flying Service Inc · Knox, INS/N 3372N135ESport Flying USA Inc · Ronkonkoma, NYBuilt 1975 · S/N 17266591N135JCNelson Bradley L · Portland, ORBuilt 1967 · S/N 670337N135TMMowbray Jerry H · Reno, NVBuilt 2001 · S/N 1384-2001N135WAHardin Melissa K · Terrell, TXBuilt 1979 · S/N 15283655N13601Szuminski Gary F · Palm City, FLBuilt 1974 · S/N 17262873N13602Dury Vernon E II · Hurst, ILBuilt 1974 · S/N 17262874N13604Kadlec Ron · Roscoe, SDBuilt 1974 · S/N 17262876N13605Bolinger Keith · Manheim, PABuilt 1974 · S/N 17262877N1360ETuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1978 · S/N 17270968N1360WRiggs Aviation LLC · Heath, TXS/N 2641N13611Stitt Gordon C · Saint Germain, WIBuilt 1974 · S/N 17262883N13612Harry Philip Scott · Asheville, NCBuilt 1976 · S/N 17702443N13618Janzen Royce D · Henderson, NEBuilt 1974 · S/N 17262886N13619Cougoule Cynthia · Hollister, CABuilt 1974 · S/N 17262887N1361CHuckaby William C Trustee · Loudon, TNBuilt 1977 · S/N 17702712N13621Fowler Gerald · Springfield, MOBuilt 1976 · S/N 17702444N13623Cloer Mark Flynt Sr · Madison, MSBuilt 1974 · S/N 17262890N13633Zanley William · Fraser, MIBuilt 1974 · S/N 17262894N13635Hartnett Richard James · Preston, CTBuilt 1974 · S/N 17262896N13639Bishop Services LLC · Ellisville, MSS/N 17262900N13644Kelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17262904N13645Pigg Brian S · Morris, ILBuilt 1974 · S/N 17262905N13646Menfi Joseph · Hopedale, MABuilt 1974 · S/N 17262906N13647Winn William D · Fallbrook, CABuilt 1976 · S/N 17702447N1364UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267035
Back to AD 80-25-07 R1