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.

N55308Charger 308 LLC · Hollis, OKBuilt 1973 · S/N 28-7310126N5530JSellers Justin Kennedy · North Augusta, SCBuilt 1967 · S/N 32-992N5530WHobgood Sidney · Klamath Falls, ORBuilt 1962 · S/N 28-621N5530ZReeves Todd J · Mosier, ORS/N 22-9319N55310Monarch M Miller · Cloverport, KYBuilt 1973 · S/N 28-7325364N55311Aeras Transport LLC · Lewes, DEBuilt 1973 · S/N 28-7305355N55313Dunning Mark · Chino Hills, CABuilt 1973 · S/N 28-7305357N55315Norman Eric Lee · Hilton Head Island, SCBuilt 1973 · S/N 28-7305359N55317Schwader Aviation LLC · Saint Joseph, MOBuilt 1973 · S/N 28R-7335214N55319Guckin Michael E · The Villages, FLBuilt 1973 · S/N 28R-7335215N5531FSchmidt David D · Atlantic Mine, MIBuilt 1968 · S/N 28-24874N5531HXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15284118N5531MPeterson Jay O · Las Vegas, NVBuilt 1980 · S/N 15284606N5531ZDarr Henry S · Drummond, MTBuilt 1962 · S/N 22-9321N55320Dragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1981 · S/N 17275157N55325Hater Michael A · Cincinnati, OHBuilt 1981 · S/N 17275158N55327Grise Paul R · Hopkinsville, KYBuilt 1973 · S/N 28-7305362N5532JRegistration Pending · Trinity, FLRegistration pendingBuilt 1967 · S/N 32-979N5532PHoudek Todd L · Roseburg, ORBuilt 1958 · S/N 24-596N5532SAks Aviation LLC · Arroyo Grande, CABuilt 1980 · S/N R18201598N5532UGorman Jeremy J · Chapman, KSBuilt 1969 · S/N 28-26249N55330Eaw Aviation LLC · Middletown, MDBuilt 1973 · S/N 28R-7335218N55331Scholl Oil & Transportation Company · Holyoke, COBuilt 1973 · S/N 28-7310128N55338Pt Arts LLC · Grand Rapids, MIBuilt 1973 · S/N 28-7325370N5533BKnudson Eddie T · Arvada, WYS/N 15283896N5533FCopenhaver Ralph L · Brady, TXBuilt 1968 · S/N 28-24876N5533PRado Richard L · Fortville, INBuilt 1958 · S/N 24-597N5533QBoldt Matthew Frederick · Santa Fe, NMBuilt 1965 · S/N 2955N5533RThompson Aaron R · Louisville, KYS/N 172RG0072N5533SNgb Construction Inc · Ceres, CAS/N R18201599N55340Air55 LLC · Charleston, WVBuilt 1973 · S/N 28-7305363N55342Dienwiebel Thomas · Santa Cruz, CAS/N 1183N55345Arrow Flite LLC · Chino Hills, CABuilt 1973 · S/N 28R-7335220N55347Roze Scott L · Port Orange, FLBuilt 1973 · S/N 28-7310129N55349Mob Aviation LLC · Auburndale, FLS/N 17275163N5534ELindsey Kelly M · Throckmorton, TXBuilt 1978 · S/N 17271883N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78N5534QPaul Richard W · San Jose, CABuilt 1965 · S/N 620N55350Haps Air Inc · Ames, IABuilt 1982 · S/N 17275164N55359Uribe Roberto · Houston, TXBuilt 1973 · S/N 28R-7335222N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934N5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 32-998N5535KHays Cory · Beaumont, TXBuilt 1978 · S/N 390-78N5535MButz Jonathan O · Mansfield, OHBuilt 1967 · S/N 121N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956N5535ZPayne Dustin J · Weirsdale, FLS/N 22-9325N55363Hardin John M · Terrell, TXS/N 34-7350206N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384N5536EJeffries And Hendley LLC · Greenwood, INBuilt 1978 · S/N 17271885N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935
Back to AD 81-18-04 R2