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.

N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454N593VSchadle Alvan G · Soldotna, AKBuilt 1947 · S/N 12-1724N5940DRunnin Rabbit LLC · Kalispell, MTBuilt 1956 · S/N 22-4603N5940PSilver Arrows LLC · Beaverton, ORBuilt 1959 · S/N 24-1030N5940UStrong Colin · Portland, ORFirst renewal noticeBuilt 1970 · S/N 28-26830N5940ZMoore Roger W · Poinciana, FLS/N 22-9811N5941WCunningham James R · Collierville, TNBuilt 1966 · S/N 28-3518N5941ZByler Jonathan P · Inman, SCBuilt 1964 · S/N 22-9812N5942DFour For Flying Inc · Holyoke, COBuilt 1956 · S/N 22-4605N5942HHendrickson Jacob N · Central, AKBuilt 1949 · S/N 16-564N5942LSimulation International Management Inc · Tulsa, OKBuilt 1969 · S/N AA1-0242N5942QBravo J Bravo Aviation LLC · Louisville, KYBuilt 1965 · S/N 831N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969N5943HPleiman Jeffrey S · Minster, OHBuilt 1949 · S/N 16-566N5943LBlackmore Marc A · Hilltop Lakes, TXBuilt 1969 · S/N AA1-0243N5943PHarper Carlyle W · Ocilla, GABuilt 1959 · S/N 24-979N5943QFreeborn Andrew B · North Las Vegas, NVBuilt 1965 · S/N 3187N5943URoth Larry · Marion, IABuilt 1970 · S/N 28-26849N5943WSallee Steven A · St George, UTS/N 28-3482N5944DBradley Dennis Michael · Myrtle Beach, SCBuilt 1956 · S/N 22-4607N5944LHoover Charles J · Logansport, INBuilt 1969 · S/N AA1-0244N5944PMay Russell L · Las Cruces, NMBuilt 1959 · S/N 24-1034N5944WFerguson Robert C · Cornelia, GAS/N 28-3529N5945DKline Paul R · Mapleton Depot, PABuilt 1956 · S/N 22-4608N5945HMccoy David L · Bear Creek, WIBuilt 1949 · S/N 16-568N5945KElston Rory · Angels Camp, CABuilt 1979 · S/N 28-7911203N5945WHensley Roger A · Rosamond, CAS/N 28-3577N5945XFarwell Theodore R · Orangeville, PAS/N 83N5945ZThompson Neal R · Magnolia, DEBuilt 1964 · S/N 22-9816N5946DInsite Design LLC · Indianapolis, INBuilt 1956 · S/N 22-4610N5946PHoward W E Barney · San Marcos, TXBuilt 1959 · S/N 24-1036N5946UBlack Howard J Jr · Bethpage, TNBuilt 1970 · S/N 28-26846N5946Z507 Flying Club Inc · Leetonia, OHBuilt 1964 · S/N 22-9817N5947DPayne David J · Eagle River, AKBuilt 1956 · S/N 22-4611N5947NGmm Records · Big Pine Key, FLBuilt 1972 · S/N 17260597N5947PJam Naba Sem LLC · Beavercreek, OHBuilt 1959 · S/N 24-1037N5947QMorales Nelson · Hendersonville, NCBuilt 1965 · S/N 3189N5947WPierce Colby · Midland, TXS/N 28-3618N5948DHumble Servant LLC · Salem, WIBuilt 1957 · S/N 22-4612N5948ETlt Legacy LLC · Fort Worth, TXBuilt 1978 · S/N 17271972N5948POverstreet Robert S · Clarksville, VABuilt 1959 · S/N 24-1039N5948QKrull Lynn · Thompson, IAS/N 3190N5949DWick Marcel P · Warsaw, NYBuilt 1956 · S/N 22-4613N5949HPierce Stephan L · Graham, TXBuilt 1949 · S/N 16-573N5949PDyer Thomas L · Sparks, NVBuilt 1959 · S/N 24-1040N5949U5949 Inc · Boulder City, NVBuilt 1970 · S/N 28-26768N5949WSutton Warren L · Loris, SCBuilt 1966 · S/N 28-3641N594AMMaarouf Mike · Taylor Lk Vlg, TXS/N 243-76N594CEBertsch Paul J · Houston, TXBuilt 2000 · S/N 4177N594CPCivil Air Patrol · Maxwell Afb, ALS/N 18282180
Back to AD 81-18-04 R2