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.

N56947Wings Of Hope · Chesterfield, MOBuilt 1973 · S/N 28-7415027N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2N5694HTischer William D · Shoreview, MNBuilt 1965 · S/N TD-243N5694UPlencner Robert E · Round Lake Beach, ILBuilt 1969 · S/N 28-26491N5694WLange James R · Tempe, AZBuilt 1963 · S/N 28-1060N56950Bodily Kent A · Washington, UTBuilt 1973 · S/N 28-7405038N56957Payne Glenn · Oregon, MOBuilt 1973 · S/N 28-7425070N56958Jackson Michael L · Nixa, MOFirst renewal noticeS/N 28-7425071N5695QBabb Douglas L · Telford, PABuilt 1965 · S/N 3046N5695W95whiskey LLC · Georgetown, MABuilt 1963 · S/N 28-1070N56964Lafollette Larry E · Strafford, MOBuilt 1973 · S/N 28-7405052N56965Brazos River Aviation LLC · Plainview, TXBuilt 1973 · S/N 28-7410036N56966West David A · Astoria, ORBuilt 1973 · S/N 28-7425067N5696HVaughan William R IV · Benton, MSBuilt 1949 · S/N 16-307N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2N5696QTrilogy Alliance Group LLC · Kearney, NEBuilt 1965 · S/N 762N5696WGiglio Tom J · South Boston, VABuilt 1963 · S/N 28-1072N56970Simoneau Todd · Sandown, NHS/N 28-7405039N56972Eby Aviation LLC · Duluth, GABuilt 1973 · S/N 28R-7435067N56973Baja Flyers Inc · San Diego, CABuilt 1973 · S/N 28-7410039N56976Tate Bird L Jr · Hammond, NYBuilt 1973 · S/N 28-7425075N56977Evans Holland L · Danielsville, GABuilt 1973 · S/N 28-7425076N56978Brindley James G · Collinsville, ALBuilt 1973 · S/N 28-7425077N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922N5697QReed Timothy W · Terrell, TXBuilt 1965 · S/N 815N5697ZLink James L · Raleigh, NCS/N 22-9532N56986Loya Armando · Whittier, CABuilt 1973 · S/N 28-7425079N56987Ravotti Air LLC · Leechburg, PABuilt 1973 · S/N 28-7415032N56988Hillerman Paul J · Vinita, OKBuilt 1973 · S/N 28-7415033N56989Kenny Zachary D · Herndon, VABuilt 1973 · S/N 28-7405040N5698QCaughell David S · Bartlesville, OKBuilt 1965 · S/N 705N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102N5698UNorby David S · Gooding, IDS/N 28-26495N5698WBurkett Aviation LLC · Hampstead, NCBuilt 1963 · S/N 28-1094N56991Schneider Stephen C · Denton, TXBuilt 1973 · S/N 28R-7435070N56992Attebery Larry J · Caldwell, IDBuilt 1973 · S/N 28R-7435071N569932c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 28-7410040N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699HHalmans John D · Baker, MTS/N 16-310N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N569BSZanetta Wayne T · Portland, ORBuilt 2014 · S/N 18-1686N569CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283071N569DPHale William J · Whitehouse, TXBuilt 2008 · S/N 90707N569FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10871
Back to AD 81-18-04 R2