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.

N554MMHodges Damon · Omaha, TXBuilt 2022 · S/N CCK-1865-1072N554PAGerken Nicholas C · Anacortes, WABuilt 1972 · S/N 28-7225475N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091N554RRegistered aircraftBuilt 1976 · S/N 28-7690382N554RVSullivan Michael · Columbia, SCS/N 24710N554TADelta Charlie Aviation LLC · Aliso Viejo, CABuilt 2003 · S/N 172S9455N554WMValdosta Flying Group LLC · Valdosta, GAFirst renewal noticeBuilt 2005 · S/N 18281666N55502Blue Valley Flying Club Inc · Denton, NES/N 28-7305401N55504University Cherokee Club LLC · Lincoln, NEBuilt 1973 · S/N 28-7305402N55505Bothwell Brandon W · Mooresville, MOS/N 28-7305403N55506Lugo Rullan Javier A · Adjuntas, PRBuilt 1973 · S/N 28-7325424N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818N5550MHamblin Michael J · Seatac, WABuilt 1967 · S/N 088N5550QReal Jonathan Dan · La Jolla, CABuilt 1965 · S/N 628N5550UFarm Air Service Inc · Pingree, NDBuilt 1969 · S/N 28-26274N5550WStone Oren · Erick, OKS/N 28-641N5550ZShippers Michael S · Williamson, NYBuilt 1962 · S/N 22-9342N55513Spoon River Flyers Inc · Avon, ILBuilt 1973 · S/N 28-7305405N55514Loomis Christopher · Cumming, GABuilt 1973 · S/N 28-7305406N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195N55516On Glideslope LLC · Middletown, DEBuilt 1973 · S/N 28R-7335247N55517Loye Mark C · Reidsville, NCBuilt 1973 · S/N 28-7310146N5551FFriest Eric J · Menomonie, WIBuilt 1968 · S/N 28-24890N5551HLeavengood Thomas Richard · Dallas, IABuilt 1949 · S/N 11-1062N5551KSchlamer Robert B · Hernando, FLBuilt 1978 · S/N 400-78N5551LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284353N5551PLarsen Jordan · Draper, UTS/N 24-616N5551QQualitair LLC Trustee · MichelstadtS/N 1276N5551UBriese Mathew · Rochester, MNBuilt 1991 · S/N 1277N5551WMurdter Lawrence M · Sunnyvale, CABuilt 1962 · S/N 28-642N5551ZKons Emily Ap · Bear Creek, WIBuilt 1962 · S/N 22-9343N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196N55525Gustafson Michael Luther · Groveland, CABuilt 1973 · S/N 28-7325426N55529Carrozzella Christopher · Wallingford, CTS/N 28-7305407N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887N5552GStracar Miro · Syosset, NYS/N 1278N5552KMob Aviation LLC · Auburndale, FLBuilt 1978 · S/N 1257-78N5552MRegistration Pending · Fayetteville, TNRegistration pendingBuilt 1980 · S/N 15284613N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570N55533Gw Aero LLC · Ponte Vedra Beach, FLBuilt 1973 · S/N 28R-7335249N5553JHein Investments LLC · Omro, WIBuilt 1968 · S/N 32-1016N5553PJones Warwick L · Torrance, CAS/N 1305N5553QLieff Daniel · Yellow Springs, OHBuilt 1965 · S/N 2965N5553UMcdonough Brian E · Harrisburg, PABuilt 1969 · S/N 28-26278N55542Colorado Cherokee Flyers LLC · Boulder, COBuilt 1973 · S/N 28-7325429N5554DValiair Limited Company Trustee · Casper, WYBuilt 1965 · S/N 28-2228N5554EValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 28-7725152N5554JC M Lindsay And Sons Inc · Lumberton, NCBuilt 1968 · S/N 32-1017N5554UNeeley Stephan B · Dighton, KSBuilt 1969 · S/N 28-26279N5554WFlyworx LLC · Kalispell, MTBuilt 1962 · S/N 28-646
Back to AD 81-18-04 R2