AD 77-13-21

Registered aircraft · 3,193

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-13-21')
    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-13-21')
  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.

N7626PZervos Fredric W · Orland Park, ILBuilt 1961 · S/N 24-2548N7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeS/N 30-700N7627PKill Stephen W · Granbury, TXBuilt 1961 · S/N 24-2837N7628YLamantia Mark V · Ebensburg, PABuilt 1964 · S/N 30-703N7630YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-706N7631YMbsp Enterprises Inc · Wilmington, DEBuilt 1965 · S/N 30-707N7632YLee Kitchell · Shelburne Falls, MAS/N 30-709N7633YMatt Younkin Airshows Inc · Siloam Springs, ARBuilt 1965 · S/N 30-710N7634PDykema Carl F · Davie, FLBuilt 1961 · S/N 24-2846N7637PFyi Adventures LLC · Ocala, FLBuilt 1962 · S/N 24-2849N7638YScientific Motive Systems Inc · Charlevoix, MIBuilt 1965 · S/N 30-717N7639YCaviris Homestead Farm LLC · Rollinsford, NHBuilt 1965 · S/N 30-718N7642PCollins Daniel R · Klamath Falls, ORBuilt 1961 · S/N 24-2856N7644PWhobrey Andrew · Bee Spring, KYBuilt 1961 · S/N 24-2858N7645YN7645y LLC · Sheridan, WYBuilt 1966 · S/N 30-1236N7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1965 · S/N 30-726N7652POso Air LLC · Missoula, MTBuilt 1961 · S/N 24-2734N7652YMetro West Ambulance · Hillsboro, ORBuilt 1965 · S/N 30-730N7653PThomason Tony L · Williamson, GABuilt 1961 · S/N 24-2703N7656PAnkney Gary L · Rector, PABuilt 1961 · S/N 24-2869N7660PRegistered aircraftBuilt 1961 · S/N 24-2873N7662PRemund Richard W · Slate Hill, NYBuilt 1961 · S/N 24-2875N7664PSandpiper Aviation LLC · Carson City, NVBuilt 1961 · S/N 24-2877N7664YSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 30-742N7669POkst George S · Slate Hill, NYBuilt 1961 · S/N 24-2882N7670PSale Reported · Edenton, NCSale reportedS/N 24-2883N7671YBailey Wryan T · Nashville, TNBuilt 1965 · S/N 30-749N7672PSantore William F · Laguna Niguel, CABuilt 1961 · S/N 24-2885N7672YBertrand Jason · Seattle, WABuilt 1965 · S/N 30-750N7674PChurches Michael D · Smyrna, TNS/N 24-2887N7674YBooth James R · Nevada City, CABuilt 1965 · S/N 30-752N7675PEhrhart Jerry L · Mount Joy, PABuilt 1961 · S/N 24-2844N7676PHanneman Robert D · Denver City, TXBuilt 1961 · S/N 24-2845N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7678PMunday Jeff R · Waverly, GAS/N 24-2889N767KPPhill-Air Inc · Dover, DEBuilt 1966 · S/N 30-1193N7681YTaft Aviation LLC · Brookhaven, NYBuilt 1965 · S/N 30-759N7683PCavel Lonnie R · Vidor, TXBuilt 1961 · S/N 24-2892N7684PPache Keith M · Montgomery, TXBuilt 1961 · S/N 24-2893N7685PPinkel Lawrence W · Albuquerque, NMBuilt 1961 · S/N 24-2894N7685YNehrbass Douglas J · Clarksville, TNBuilt 1965 · S/N 30-765N7686YMontana Leasing Group LLC · Park City, UTBuilt 1965 · S/N 30-766N7689YGitlow Stuart · Woonsocket, RIBuilt 1965 · S/N 30-769N7692PKelly Joseph · Austin, TXFirst renewal noticeBuilt 1961 · S/N 24-2902N7692YAloof Aviation LLC · Denver, COBuilt 1965 · S/N 30-774N7693PCrane James M · Clayton, NCBuilt 1961 · S/N 24-2903N7693YSkywalker Flight School LLC · Adrian, MIBuilt 1965 · S/N 30-775N7694PN7694p Enterprises Inc · Dover, DEBuilt 1961 · S/N 24-2904N7695YGriffith David B · Gilmer, TXBuilt 1965 · S/N 30-777
Back to AD 77-13-21