AD 80-01-06

Registered aircraft · 2,130

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-01-06')
    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-01-06')
  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.

N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254N24472Payne Richard L · Flint Hill, VABuilt 1977 · S/N 15280272N24486Wilson Seth · Shafter, CABuilt 1977 · S/N 15280283N24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280290N24501Dsr Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 15280292N24512Moran Erick A · Orange, CABuilt 1977 · S/N 15280300N24522Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280309N2452UPuryear Rodney K · Pampa, TXBuilt 1982 · S/N 172RG1049N24530Mayfield Jon David · Dublin, TXBuilt 1977 · S/N 15280313N24532Christiansen Aviation LLC · Wilmington, DEBuilt 1977 · S/N 15280315N24544Comer Dwayne M · Glendale, AZS/N 15280323N24546Valestin Donald P · Queen Creek, AZBuilt 1977 · S/N 15280325N24553Jensen Aviation LLC · Rancho Cucamonga, CABuilt 1977 · S/N 15280328N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365N24773Grusy Norman D · Portland, ORS/N 15280369N24775Cal Aggie Flying Farmers Inc · Davis, CABuilt 1977 · S/N 15280371N24781Shaw Erin · Reno, NVBuilt 1977 · S/N 15280375N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314N24816Graves James A Trustee · Norman, OKBuilt 1977 · S/N 15280396N24831Bishop Darin R · Livermore, CABuilt 1977 · S/N 15280403N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432N24887Sunrise Aviation Inc · Ormond Beach, FLS/N 15280433N24895Lokker Dirk E · Oakdale, CABuilt 1977 · S/N 15280438N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445N24920Springett Justin · Boulder, COS/N 15280450N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459N24947Aty Aviation Inc · Watertown, SDS/N 15280464N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490
Back to AD 80-01-06