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.

N152GFBright Shaji · Martinez, GABuilt 1978 · S/N 15282309N152GSBitondo Steven S · Mamaroneck, NYBuilt 1978 · S/N 15282256N152GTHansen Nelse · Lawrenceville, GABuilt 1977 · S/N 15279503N152HFBaier Dale Edwin · Colleyville, TXBuilt 1977 · S/N 15279555N152HRWarner James A · Watertown, NYBuilt 1980 · S/N 15284697N152HWWuertz Errol Gene Jr · Mcpherson, KSBuilt 1978 · S/N 15281995N152JPatterson Casey Paul · Kinston, ALBuilt 1979 · S/N 15283162N152JLCivil Air Support LLC · Phoenix, AZBuilt 1978 · S/N 15281834N152LBurdick Rich · Montrose, COBuilt 1979 · S/N 15283964N152LEBirjandi Akbar · Westlake Village, CABuilt 1978 · S/N 15282306N152LTMorcom Aviation Services Inc DBA · Everett, WABuilt 1981 · S/N 15285262N152MCOkechukwu Christopher · Paramus, NJBuilt 1977 · S/N 15279798N152MFMja Flight LLC · Justin, TXBuilt 1981 · S/N 15284867N152MMWiegler Michael · Austin, TXS/N 15280836N152NSNovember Sierra Aviation LLC · Oneill, NES/N 15279673N152PFTfa Holding Corp · Daytona Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 15285380N152PRSantaella Guillermo R · Huntley, ILBuilt 1979 · S/N 15283504N152PTWiger Theodore L · Falcon Heights, MNBuilt 1977 · S/N 15280065N152RAIndiana State University · Terre Haute, INS/N 15279562N152REWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284555N152SJBonus Kurt W · Wind Lake, WIBuilt 1978 · S/N 15282476N152SKCade Matt C · Canton, TXS/N 15281404N152SLAvtech Group LLC · Saint Augustine, FLBuilt 1978 · S/N 15282742N152SPFogelberg Scot · Stillwater, MNBuilt 1978 · S/N 15282536N152SQSpartan Education LLC · Tulsa, OKBuilt 1980 · S/N 15284185N152STMckenney Vernon L · Rodeo, CAFirst renewal noticeS/N 1558N152TRWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281247N152UCSkylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15281879N152UFWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15284001N152WBing Kenneth · Millersport, OHS/N 15282154N152WAAces High Aviatio LLC · Long Beach, CABuilt 1979 · S/N 15283845N152WHBecker Steven Hollyfield · New Meadows, IDBuilt 1977 · S/N 15279700N152XTDiaz Alcides L · Archbald, PABuilt 1979 · S/N A1520907N153MTMiller Nathan · Irwin, OHBuilt 1978 · S/N 15282694N153SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281770N154JBLevingston Brendan W · Denali Park, AKBuilt 1979 · S/N 15282685N154SKReign Aviation LLC · Fresno, CABuilt 1978 · S/N 15282110N155SKPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282657N156SKBrenny Christopher D · Burlington, WIBuilt 1981 · S/N 15285035N157NHRegistered aircraftBuilt 1981 · S/N 15285106N157SKGriffith Aviation Inc · Griffith, INBuilt 1980 · S/N 15284820N159SKSeacrest Enterprises LLC · Asheville, NCBuilt 1979 · S/N A1520900N159TCShooting Star Museum · Devine, TXBuilt 1977 · S/N 15280724N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115N162FKrueger Luke T · Anchorage, AKS/N 15279773N162PTAero Fliers LLC · Kalispell, MTBuilt 1981 · S/N 15285278N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120
Back to AD 80-01-06