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.

N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880N6458LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284400N6458PHutchison Joseph C · Mebane, NCBuilt 1959 · S/N 24-1573N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531N6459LFalcon Financial Solutions · Meadow Vista, CABuilt 2000 · S/N 30018CN6459PJaeger Timothy S · Mukwonago, WIS/N 241574N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645N6459ULinck Market Inc · Little Rock, ARBuilt 1962 · S/N 2205N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305N645CHWebster Jason M · Orlando, FLBuilt 1972 · S/N 327240135N645DBBailey Dennis L · Oakdale, CABuilt 2004 · S/N 24345N645DDAmes Donald L Trustee · Park City, UTBuilt 2010 · S/N 81775N645DTScenic Mountain Air Inc · Moose Pass, AKBuilt 1982 · S/N 18-8309022N645EJFogelin Eric S · Shasta, CABuilt 2008 · S/N 645EN645EPChristiansen Aviation LLC · Wilmington, DEBuilt 2015 · S/N 172S11611N645FCFlorida Dept Of Agriculure & Consumer Services · Tallahassee, FLBuilt 2021 · S/N 18283152N645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553N645FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843705N645KAHelocraft Holding Co Inc · Pembroke Pines, FLBuilt 2009 · S/N S1931N645LCJohnston Laura S · Seattle, WABuilt 2003 · S/N 263N645MMikkelsen Timothy O · Wasilla, AKBuilt 2014 · S/N CC18-0068N645NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881146N645PAzul Services LLC · Bozeman, MTBuilt 2000 · S/N 172S8510N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240N645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTBuilt 2009 · S/N 90541N645RFHagge Hal E · Eagle River, AKBuilt 1968 · S/N 18-8711N645SStewart Dennis M · Fernley, NVBuilt 2015 · S/N 72943N645SAGerrish Ronald M · San Antonio, TXBuilt 2005 · S/N S-0007N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524N645SPRegistration Pending · Bennett, CORegistration pendingBuilt 1998 · S/N 172S8052N645XAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10692N645ZAzul Services LLC · Bozeman, MTBuilt 2009 · S/N 172S10928N64608A S Air LLC · Lantana, FLS/N 17275592N6460DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 19640N6460LRichmor Aviation Inc · Scotia, NYBuilt 1980 · S/N 15284401N6460MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284742N6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1959 · S/N 24-1575N6460QDel Gado Raul L · Victorville, CABuilt 1967 · S/N 670539N6460TDavey Douglas H · Worley, IDBuilt 1985 · S/N R18202031N6460UHayes Toby G · Idaho Falls, IDBuilt 1962 · S/N 2206N64611Great North Air LLC · Shelburne, NHBuilt 1982 · S/N 17275593N64617Melbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275594N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425N6461PSullenger Charles H · Statesboro, GAS/N 24-1576N6461QGanos Christ · Brookfield, WIBuilt 1967 · S/N 680003N6461RBetsy N6461r LLC · Novato, CABuilt 1966 · S/N 28-21648N6461VRegistered aircraftBuilt 1980 · S/N 172RG0716N6461WOverstreet Aviation LLC · Sunray, TXBuilt 1964 · S/N 28-20534
Back to AD 81-18-04 R2