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.

N170SUTop Flight Consulting LLC · Fort Myers, FLBuilt 1979 · S/N 152-83248N172BDMurawski Rene · Clarkston, MIBuilt 1981 · S/N 172RG0960N172CESan Diego Community College District · San Diego, CAS/N 172RG0529N172DPSuperior Aviation Gateway LLC · Tampa, FLBuilt 1980 · S/N 172RG0465N172KAVenture North Aviation LLC · Cloquet, MNS/N 172RG0854N172MMEwing & Coryell LLC · Nixa, MOS/N 172RG0286N172PESale Reported · Kenmore, WASale reportedBuilt 1979 · S/N 172RG0042N172RGMaxwell Don P II · Longview, TXBuilt 1979 · S/N 172RG0083N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149N172ZGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 828N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074N177BDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281660N17RRRiverside Flight Center Inc · Tulsa, OKBuilt 1979 · S/N 15284134N185SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282935N185SRHillbilly Holler LLC · Missoula, MTBuilt 1979 · S/N 15283215N18HTTobler Niccolo Sunny · Anchorage, AKS/N 15282364N191FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285939N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979N197THN197th LLC · Sammamish, WABuilt 1977 · S/N 15280093N2034NNorthstar Aviation Leasing LLC · Merritt Island, FLBuilt 1978 · S/N 15282073N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195N212MBEuro 2000 Inc · Merritt Island, FLBuilt 1978 · S/N 15279920N216CLMisamore Steven Edward · Mount Juliet, TNS/N 15284706N216DVBusch-Joss Elizabeth M · Blue Point, NYBuilt 1977 · S/N 15280927N216JARuble Howard L Jr · Spartanburg, SCBuilt 1980 · S/N 172RG0467N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544N22JNRegistered aircraftBuilt 1979 · S/N 172RG0215N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714N240SUOhio State University · Columbus, OHBuilt 1981 · S/N 15285153N24214Mckinney Brett A · Hackleburg, ALBuilt 1977 · S/N 15280154N24242Fly Sky Ads LLC · Manalapan, NJBuilt 1977 · S/N 15280170N24260Aerial Banners Inc · Pembroke Pines, FLBuilt 1977 · S/N 15280180N24261Citabria Inc · Auburn, CABuilt 1977 · S/N 15280181N24264Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280183N24266Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280185N24269Sioux Air Inc · South Sioux City, NEBuilt 1977 · S/N 15280186N24296Cc Aviation Inc · Tracy, CABuilt 1977 · S/N 15280201N24305Woolsey Joseph A · Squaw Valley, CABuilt 1977 · S/N 15280206N24313Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280210N24315Cubicle Concepts Inc · New Holland, PABuilt 1977 · S/N 15280212N24327Centurion Aviation · Salina, KSFirst renewal noticeBuilt 1977 · S/N 15280218N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230
Back to AD 80-01-06