AD 77-01-01

Registered aircraft · 16,382

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:77-01-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-01-01')
  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.

N1076QExecutive Flight Institute LLC · Murrieta, CABuilt 1977 · S/N 28-7790374N1076XMarston Lester J · Ukiah, CABuilt 1975 · S/N 28-7515383N1077XJny LLC · Riverview, FLBuilt 1975 · S/N 28R-7535234N1079HJaremus Kent M · Olathe, KSS/N 28-7725131N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231N1080XFlying With Fitch LLC · Porter, TXS/N 28-7525278N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997N108WMMoran William J · Media, PABuilt 1978 · S/N 32-7840187N1092TH4s Aviation LLC · Longview, TXS/N 28-25565N1092XNice Curtis A · Fort Myers, FLBuilt 1975 · S/N 28R-7535230N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239N1096TEvans Charles B · Benbrook, TXS/N 28-26284N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482N10PJMiller Kenneth R · Russellville, KYBuilt 1967 · S/N 32-40285N1102NWorld Class Athletic Surfaces Inc · Leland, MSBuilt 1968 · S/N 32-40756N1102XMarak Enterprises LLC · Galena, MOBuilt 1975 · S/N 28-7505210N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308N1108HAdk Flying Club Inc · Ballston Spa, NYBuilt 1976 · S/N 28-7715309N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389N1109XBruno Michael J · Pittsburg, CABuilt 1975 · S/N 28-7505211N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277N110MSMcaleer Scott · Scranton, IABuilt 1969 · S/N 28R-35194N110TNMaloney Casey · Placerville, CABuilt 1972 · S/N 28-7305054N1112XArrow Flyers LLC · Englewood, COS/N 28R-7535247N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126N1117XHarshman James M · Washington, PABuilt 1975 · S/N 28R-7535248N1118XKdr Avgroup LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535249N1118ZMoorhouse Mark A · Santa Fe, TNBuilt 1963 · S/N 28-1118N111AEMatthews Timothy I · Belvidere, NJBuilt 1970 · S/N 28R-35809N111AJBergin Donald M · Ormond Beach, FLBuilt 1972 · S/N 32-7200041N111AZ360 LLC · Carson City, NVFirst renewal noticeBuilt 2000 · S/N 28-43311
Back to AD 77-01-01