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.

N524TLMoroni Nanette Teresa DBA · Orlando, FLBuilt 1965 · S/N 3086N52501Freedom Works Consulting LLC · Louisville, KYS/N 17274541N52503Mooney 52503 Flyers · San Diego, CAS/N 24-3091N52516Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274546N5251ERhinelander Flying Service Inc · Rhinelander, WIBuilt 1977 · S/N 17271799N5251HLuyster Roy A · Rochelle Park, NJBuilt 1975 · S/N 17265384N5251RLong Island Aviators LLC · Seaford, NYS/N 17263465N5251THubka Charles A · Beatrice, NEBuilt 1981 · S/N R18201842N52521Rebel Aviation Inc · Liberty, MOFirst renewal noticeBuilt 1980 · S/N 17274547N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327N5252XGlick Caleb A · Hillsville, VABuilt 1969 · S/N 190N5253EWarren Clark A · Henderson, NVBuilt 1983 · S/N 18268303N5253RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263467N5253UKronauge Frank A · Dayton, OHS/N 172RG0302N52543Berry Curtis L · Williamsport, MDBuilt 1977 · S/N 177RG1206N52546Eaton Rosemary D · Vernon, NYS/N 17274552N5254DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272473N5254JWorcester Naa Flying Club · Worcester, MABuilt 1980 · S/N 17273745N5254KStone To Glass LLC · Lake Worth, FLBuilt 1980 · S/N 17274033N5254NOrbelo Robert W · Farmington, NMS/N 24-1663N5254TMillion Air LLC · Las Vegas, NVS/N 24-3093N5254XDahl Kevin A · Fargo, NDBuilt 1969 · S/N 704N5255ABishop Michael J · Lima, OHBuilt 1979 · S/N 21063329N5255SAkc III Aviation LLC · Port Saint Joe, FLS/N 24-1655N5255UFlight Gear Aviation LLC · Pickerington, OHBuilt 1980 · S/N 172RG0304N52569Kf Air Holdings LLC · Indianapolis, INS/N 17274557N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475N5256HHenley Robert J · Jeffersonville, INS/N 17265385N52578Wall Leslie A Trustee · Stevensville, MDBuilt 1977 · S/N 177RG1207N52579Urquhart David L · Winchendon, MABuilt 1977 · S/N 177RG1208N5257HWellman David H · Eugene, ORBuilt 1975 · S/N 17265386N5257QNott Michael A · Lake Havasu City, AZS/N 24-3074N5257RTheodossiou Chris · Mandeville, LABuilt 1974 · S/N 17263471N5257SSchumaker Grant E · Wichita, KSBuilt 1980 · S/N R18201526N5257TLangel Michael L · Huntington Beach, CAS/N 24-1661N52582Wheeler Kevin K · Thornville, OHS/N 177RG1209N52585Colley Reid W · Pauls Valley, OKS/N 177RG1210N52589Audritsh John E DBA · Indianapolis, INBuilt 1977 · S/N 177RG1211N5258BMathis Ryan B · Madison, ALS/N 15283818N5258GMooney N5258g LLC · Kalispell, MTS/N 24-1662N5258RZwiesler Thomas F · Ellington, CTBuilt 1974 · S/N 17263472N5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 17275032N52593Mccarthy Justin P · Western Springs, ILBuilt 1980 · S/N 17274559N5259CMcsorley John A · North Augusta, SCS/N 24-3094N5259HTrifunovic Stefan · Grosse Pointe Park, MIBuilt 1975 · S/N 17265387N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473N525CSPrivitt Bret J · Forest Hill, TXBuilt 1973 · S/N 270-73N525HFVintage Wings Aircraft LLC · Center Point, INBuilt 1977 · S/N 15280442N525JGFlycarolina LLC · Concord, NCS/N 172RG0178N52602Hutch Aviation Inc · Zavalla, TXBuilt 1980 · S/N 17274562
Back to AD 80-25-07 R1