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.

N9057JBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1966 · S/N 28-3091N9057LKing Nathan A · Dunkirk, MDS/N 769-70N9057VBrossard Pierre · New Albany, MSBuilt 1968 · S/N 690005N9057WWright Laine Properties LLC · Raleigh, NCBuilt 1965 · S/N 28-10651N90586Lauff Samuel Jr · Ocala, FLS/N 64-18014N9058DBallard David L Trustee · Chugiak, AKBuilt 1958 · S/N 22-6198N9058JRubinic Brandon S · Harrisburg, PABuilt 1966 · S/N 28-3092N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70N9058VPellikan Jake E · Staten Island, NYBuilt 1968 · S/N 690006N9059DGladstone Stephen · Mesa, AZS/N 20570N9059QStevens Donald F · Canton, GAFirst renewal noticeBuilt 1981 · S/N 0143N905AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881945N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651N905CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8329N905CZSmith Stuart · Walla Walla, WABuilt 2020 · S/N 1338N905DWDue South LLC · Wilmington, DEBuilt 2006 · S/N 22780N905EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12967N905GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 339N905KTmd Enterprises LLC · Amarillo, TXBuilt 2006 · S/N 1020-2006N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516N905NRState Of Minnesota · Grand Rapids, MNBuilt 2006 · S/N 479-2006N905RKRay Robert E · Graham, WABuilt 2011 · S/N 80839N905RSSeman Richard M · Pittsburgh, PABuilt 2011 · S/N 001N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967N905XCFlores-Cortes Jose Natividad · Los Angeles, CABuilt 2011 · S/N 5129N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9060JGillis Joseph V · Tempe, AZBuilt 1966 · S/N 28-3094N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70N9060WDoyle Thomas M · New City, NYBuilt 1965 · S/N 28-10655N90618Gm Homes Inc · Campobello, SCBuilt 1966 · S/N 65-18251N9061DRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-6426N9061RCavender Matt · Howe, TXBuilt 1967 · S/N 47-0696N9061SObrien Derrick P · Lehigh Acres, FLS/N 76-0609N9061VRegistered aircraftBuilt 1968 · S/N 690007N90623Cassady Grant W · Tulsa, OKBuilt 2008 · S/N 40628N9062DKing Gary W Jr · Anchorage, AKBuilt 1958 · S/N 18-6427N9062JVernon Sharnell Tamieko · Phoenix, AZS/N 28-3096N9062KMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7816187N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70N9062VJacobsen Dennis S · Reno, NVBuilt 1968 · S/N 690009N9062WBartling David Ryan · Mesa, AZBuilt 1965 · S/N 28-10659N9063DHanson Lavon T · Saint Ignatius, MTBuilt 1958 · S/N 18-6428N9063JHardison Samuel H · Mountain View, ARS/N 28-3097N9063LKnutson Flying Service Inc · Tioga, NDBuilt 1965 · S/N 1801N90649Boatman John H Jr · Smyrna, TNBuilt 2002 · S/N 225N9064JSolomon Michael Lee · Hope Mills, NCBuilt 1966 · S/N 28-3099N9064LHendrickson Don W · Helena, MTBuilt 1970 · S/N 247-70N9064VMitchell Benjamin · Riverdale, UTBuilt 1968 · S/N 690010N9064WDerbyshire Alan C · Marathon, FLBuilt 1965 · S/N 28-10661N9065VRussell Robert D · Aurora, COBuilt 1968 · S/N 690009
Back to AD 81-18-04 R2