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.

N201YF2themoon LLC · Riverton, WYBuilt 1978 · S/N 24-0514N201YGN201yg LLC · Rapid City, SDBuilt 1978 · S/N 24-0515N201YHNoomen Lyle R · Currie, MNS/N 24-0516N201YJN201yj LLC · Acworth, GAFirst renewal noticeS/N 24-0517N201YKFAA Registrations LLC Trustee · St Peter JerseyS/N 24-0518N201YLDimarco Matthew J · Leonardtown, MDBuilt 1978 · S/N 24-0519N201YMPichitino James · San Luis Obispo, CABuilt 1990 · S/N 24-1696-14N201YNCampo Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0491N201YPBrocoum Michael · New York, NYBuilt 1978 · S/N 24-0512N201YTJet Dawg Aviation LLC · Okeechobee, FLBuilt 1977 · S/N 24-0176N201YVMay Richard B · Mammoth Lakes, CABuilt 1978 · S/N 24-0528N201ZCavu Holdings LLC · Medon, TNBuilt 1978 · S/N 24-0542N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415N201ZDFlight Eval LLC · Flagler Beach, FLBuilt 1978 · S/N 24-0749N201ZESoeby Paul R · Walhalla, NDBuilt 1978 · S/N 24-0638N201ZFForever Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0650N201ZGHaugen Mark K · Newhall, CABuilt 1978 · S/N 24-0640N201ZHBailey Michael D · Dover, FLS/N 24-0535N201ZLDressler David C · Mission Viejo, CABuilt 1978 · S/N 24-0536N201ZNJp Martin Service LLC · Hialeah, FLBuilt 1978 · S/N 24-0537N201ZQReber William T · Terrace Park, OHBuilt 1978 · S/N 24-0539N201ZRYost Robert L · Bridgeport, WVBuilt 1978 · S/N 24-0540N201ZTHn Journey LLC · Lewes, DEBuilt 1978 · S/N 24-0543N201ZVLeung Michael H · Millstone Township, NJBuilt 1978 · S/N 24-0546N201ZWHoward Richard A · Venice, FLBuilt 1981 · S/N 24-1194N201ZYFlight Associates Inc · Malabar, FLS/N 24-0551N201ZZSky West Aviation Inc Trustee · Albuquerque, NMS/N 24-0745N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644N20207Disheroon Donald · Houston, TXS/N 17261095N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102N20217La Valle Jacque D · Lexington Park, MDBuilt 1977 · S/N 17702646N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104N20219Koenitzer Judson B · Chetek, WIS/N 17261105N2021QHamilton Gregory J · Avon Lake, OHBuilt 1973 · S/N 177RG0421N20221Ohair Mark O · Lampasas, TXFirst renewal noticeBuilt 1972 · S/N 177RG0273N20222Coe Douglas R · Roswell, GAS/N 17702647N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111N20229Sale Reported · Wilmington, DESale reportedS/N 17702649N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116
Back to AD 80-25-07 R1