OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-02-R2')
    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-02-R2')
  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.

N9250LBullitt Richard T · Humble, TXBuilt 1971 · S/N AA1A-0150N92515Bowen Bruce C · Sturgis, SDBuilt 1946 · S/N 12-38N92536Ott Dean R · Carrollton, OHBuilt 1946 · S/N 12-60N92538Todd Terry A · Firth, IDBuilt 1946 · S/N 12-64N9253LMaj Holdings LLC · Norfolk, VABuilt 1971 · S/N AA1A-0153N92545Grald Jonathan · New Hampton, NYBuilt 1946 · S/N 12-74N92547Haynes John · Gainesville, GABuilt 1946 · S/N 12-76N92549Mackay Chadd P · Spokane Valley, WABuilt 1946 · S/N 12-78N9254LDeyager John E · Chapel Hill, TNBuilt 1971 · S/N AA1A-0154N92556Bender Ronald J · Columbus, NMBuilt 1946 · S/N 12-85N9255LBegley Edward R · Glasgow, KYBuilt 1971 · S/N AA1A-0155N92563Tri-County Sprayers Inc · Hamlin, TXBuilt 1946 · S/N 12-92N92569Bauer Dereck R · Springfield, ORBuilt 1946 · S/N 12-98N92571Ag Air Squadron Three LLC · Saint Joseph, ILBuilt 1946 · S/N 12-101N92582Eichner Kenneth B · Ketchikan, AKBuilt 1946 · S/N 12-112N92583Church Bryce G · Lava Hot Springs, IDBuilt 1946 · S/N 12-113N92585Hines Thomas J · Anchorage, AKBuilt 1946 · S/N 12-115N92587Harper Thomas R · Lakeway, TXBuilt 1946 · S/N 12-122N92588Graham Aviation LLC · Baton Rouge, LABuilt 1946 · S/N 12-118N92592Haggenmacher Scott · Jonesboro, ARBuilt 1946 · S/N 12123N9259LWright Brandon · Cave City, KYS/N AA1A-0159N9261LDuran Nick R · Cleburne, TXBuilt 1971 · S/N AA1A-0161N9266TCrosswind Aviation Inc · Oakley, KSS/N 38-78A0306N9268TRooney James J · Friendswood, TXS/N 38-78A0307N92713Laughter John Eric · Brookhaven, GABuilt 1946 · S/N 12-148N92727Routh David A · New Richland, MNS/N 12-163N92732Hagman Jeffrey W · St Bonifacius, MNBuilt 1946 · S/N 12-168N92736Larkin Marion J · Salome, AZBuilt 1946 · S/N 12-173N92740Sandstrom David E · Anchorage, AKS/N 12-177N92748Mullins Esten R · El Paso, TXS/N 12-186N92751Allred Gina D Administrator · Centre, ALBuilt 1946 · S/N 12-191N92752Posey Timothy L · Shirley, ARBuilt 1946 · S/N 12-193N9275LEn Productions LLC · Grand Rapids, MIS/N AA1A-0175N9275TMoore Joseph P · Stillwater, OKBuilt 1978 · S/N 38-78A0312N92763Bump Jennifer P · King Salmon, AKBuilt 1946 · S/N 12-207N92769Aero Bear Aviation LLC · Atlanta, GABuilt 1946 · S/N 12-214N9276LCueva Arturo A · Los Angeles, CABuilt 1971 · S/N AA1A-0176N92772Skyward Aviation Enterprises LLC · Raleigh, NCBuilt 1946 · S/N 12-218N92774Anderson Paul D · Anchorage, AKBuilt 1946 · S/N 12-220N92775Rector Calvin C · Karlstad, MNBuilt 1946 · S/N 12-221N9277LMoseley Warren C · Arlington, TXBuilt 1971 · S/N AA1A-0177N9277TCrouse Dewayne O · Eagle River, AKBuilt 1946 · S/N 12-157N9278TSanderson Nicholas DBA · Olivet, MIBuilt 1978 · S/N 38-78A0314N92792Arton Brad D · Prairieville, LABuilt 1946 · S/N 12-238N927TGStacy David D · Chugiak, AKBuilt 1946 · S/N 12-182N927WTHaugen Delos L · Burlington, NDBuilt 1966 · S/N 438N9280LFennig Richard L · Virginia Beach, VABuilt 1971 · S/N AA1A-0180N9284LWilkins Perry · Chesapeake, VABuilt 1971 · S/N AA1A-0184N9284TGarrett Randall F · Fort Walton Beach, FLBuilt 1978 · S/N 38-78A0319N9289LMainland Thomas L · Kansasville, WIBuilt 1971 · S/N AA1A-0189
Back to AD 80-25-02 R2