AD 81-18-04 R2

Registered aircraft · 81,733

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

N6064RSvetfur Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10246N60658Euroaviation Inc · KematenBuilt 1981 · S/N V57N6065BStohr Martin C · Palm Coast, FLBuilt 1978 · S/N AA1C0198N6065HNoble Mark · Memphis, TNBuilt 1977 · S/N 28-7890204N6065LAvolant Aviation LLC · Mooresville, NCBuilt 2006 · S/N 172S10250N6065MPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10251N6065PS R Liner LLC · Canton, MABuilt 2006 · S/N 172S10253N6065QShick Douglas Todd · Chester, VAS/N 3250N6065WBeyond Aviation LLC · Jacksonville, FLBuilt 1964 · S/N 28-20077N6066DDaily John F · Chugiak, AKBuilt 1957 · S/N 22-4719N6066HFlaps Inc · Cincinnati, OHBuilt 1977 · S/N 28-7890205N6066LBrown Andy · Cypress, TXBuilt 1972 · S/N AA5-0166N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398N6066QArmagost James C · Belton, TXBuilt 1965 · S/N 897N6066WAshpaugh Larry D · Hilltop Lakes, TXBuilt 1964 · S/N 28-20078N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6067QFrantz Joseph M · Gill, COBuilt 1965 · S/N 898N6068DThorn Blake A · Coupeville, WAS/N 22-4721N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392N6068PGear Down Hangar LLC · Phoenix, AZBuilt 1959 · S/N 24-1164N6068QPressley Jerry · Morristown, TNBuilt 1965 · S/N 899N6068RPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 6006647961210N6068WRivera Jose · Spencer, WVFirst renewal noticeS/N 28-20080N6069FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020151N6069NAurand Bradley · Selinsgrove, PABuilt 1979 · S/N 61P06717963314N6069YAngelman Aviation LLC · Prosper, TXBuilt 1966 · S/N 27-3267N606AAero Services Lc · Woods Cross, UTS/N 22-9N606AGWhipple Marvin G · Pawnee Rock, KSBuilt 2003 · S/N 80433N606APMacair Leasing LLC · Cocoa, FLS/N 3064N606BHWhite Montie Eugene Trustee · Hartsville, TNBuilt 2000 · S/N 002BHN606BJHickman Smith Dean John · Wilton, CABuilt 2007 · S/N 23992N606CPGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-036N606DEliason John P · Westcliffe, COBuilt 2011 · S/N 71283N606DBBode Aviation Inc · Albuquerque, NMBuilt 2002 · S/N 17281141N606DCWhiteside John M · Sandy Valley, NVBuilt 2024 · S/N L2K-154N606DPRegistered aircraftBuilt 2006 · S/N 40387N606EAdvantage Data Systems Inc · Zionsville, INBuilt 2017 · S/N 41078N606EAOakmere Leasing LLC · Norton Shores, MIBuilt 1979 · S/N 28-7916477N606ERHansen Justin L · St George, UTS/N MB-397N606GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15284058N606HSMyers Kenneth K · Rangely, COBuilt 2003 · S/N 118N606JPWilkins Jonathan · Woodridge, ILBuilt 2018 · S/N 1103N606LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2008 · S/N 172S10708N606NDDavidson Flight Service LLC · Gig Harbor, WABuilt 2013 · S/N 172S11296N606NTGimli Son LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1972 · S/N 653N606PRReichman Paul · Cornwall, NYBuilt 2016 · S/N 41624N606RFFitts Robert D · Independence, ORBuilt 2025 · S/N 1N606RVSuper D LLC · Nunn, COBuilt 2016 · S/N 22851N606RWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 177RG0980
Back to AD 81-18-04 R2