OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N25820Sale Reported · Xxx, OKSale reportedBuilt 1977 · S/N 15280799N25836Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280808N2584ASorrells David · Gladewater, TXBuilt 1978 · S/N 38-78A0765N25852Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 15280817N25855Williams Stephen W · Granbury, TXBuilt 1977 · S/N 15280820N25860Sorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 15280825N2586AInternational Air Services Inc Trustee · Carson City, NVS/N 38-78A0766N2586BAnderson Miles D · Reno, NVBuilt 1978 · S/N 38-79A0133N2586DStay-Air-Borne LLC · Locust Grove, GABuilt 1978 · S/N 38-79A0385N2586MSmith Randall A C · North Pole, AKBuilt 1946 · S/N 12-1047N2587CRegistration Pending · Kalispell, MTRegistration pendingBuilt 1978 · S/N 38-79A0245N2587DLindee Thomas W · Minnetonka, MNBuilt 1978 · S/N 38-79A0386N2587NExecutive Air Leasing Inc · Minneapolis, MNBuilt 1979 · S/N 38-79A0932N2588DThurmond Georgette E · Palmdale, CABuilt 1978 · S/N 38-79A0387N25895Registered aircraftBuilt 1981 · S/N 38-81A0080N25899Ace Aircraft Leasing Inc · Nazareth, PABuilt 1977 · S/N 15280842N2589BOsterman Jeremiah E · Sautee, GAS/N 38-79A0135N258DMMellen Dale · Marysville, OHBuilt 2022 · S/N 258N258TDiamond X LLC · Elko, NVBuilt 1953 · S/N 18-2372N25907Bishop Kenneth P · Griffin, GABuilt 1977 · S/N 15280849N2590CKelley Judson R · Olympia, WABuilt 1978 · S/N 38-79A0247N2590GAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0560N25914Aces High Aviation LLC · Long Beach, CABuilt 1977 · S/N 15280854N25918Wichita Area Technical College · Wichita, KSBuilt 1977 · S/N 15280857N2591GRivero Mark A · Henderson, NVBuilt 1979 · S/N 38-79A0563N2591MFlyer One LLC · Palm Harbor, FLBuilt 1946 · S/N 12-950N25922Byrd-Pettit Caroline A · Smithfield, NCS/N 15280859N25929Trevisan Hugo S · Polk City, FLBuilt 1981 · S/N 38-81A0105N2592FDunlap Burton D · Mooresville, NCS/N 111N2592LLondke Kevin S · Lexington Park, MDBuilt 1979 · S/N 38-79A0774N25932California In Nice Inc · San Jose, CABuilt 1977 · S/N 15280864N25948Indiana State University · Terre Haute, INBuilt 1977 · S/N 15280875N2594GRuddle Kaleb T · Lawrenceburg, TNBuilt 1967 · S/N 448N2594MBertke Matthew B · Anchorage, AKS/N 12-1037N2594NDivinity Enterprises LLC · Wilmington, DEBuilt 1979 · S/N 38-79A0933N25950Gist Phillip C · Fort Worth, TXBuilt 1977 · S/N 15280877N25959South Texas Air Force LLC · Mission, TXS/N 38-81A0087N2596BWynn Ralph H · Tulsa, OKBuilt 1978 · S/N 38-79A0143N2596EMeigs Jonathan H · Corning, NYBuilt 1978 · S/N 38-78A0483N25976Skylogix Aircraft LLC · La Verne, CAS/N 15280890N25979Andrews University · Berrien Springs, MIS/N 15280892N2598GRybacki Peter L · Great Barrington, MABuilt 1967 · S/N 423N25995Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280903N25998Carlin Delbert J · Blanchard, OKS/N 15280905N25DBStranberg Jonathan E Sr · White Heath, ILBuilt 1993 · S/N 83N25EDHaynes Douglas Edward · Watkins, COS/N 418N25EFXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15280552N25HTTobler Hans P · Anchorage, AKS/N 15281787N25ZAAngels Wings LLC · Chambersburg, PABuilt 1997 · S/N 20-0025N26008Off LLC · Lonoke, ARBuilt 1981 · S/N 38-81A0097
Back to AD 80-25-02 R2