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.

N5783HBellas Bryan T · Geneva, OHBuilt 1949 · S/N 16-398N5783ULindberg Kyle J · Pahrump, NVBuilt 1970 · S/N 28-26607N5783WDillard Joseph · Thaxton, MSBuilt 1964 · S/N 28-1660N5783ZAlix Brian R · Valley Falls, NYBuilt 1963 · S/N 22-9627N5784FCrocker James Fuller · Trussville, ALBuilt 1968 · S/N 28-25090N5784HWright William J · Raeford, NCS/N 16-399N5784PMiller Jeffery Allen · Menifee, CAS/N 24-863N5784QArias Raymond G · Wesley Chapel, FLS/N 3094N5784UMchenry Charles · Siloam Springs, ARBuilt 1970 · S/N 28-26608N5785LVance Marc G · Canal Winchester, OHBuilt 1969 · S/N AA1-0185N5785PSmith Clyde R Jr · Lock Haven, PABuilt 1959 · S/N 24-864N5785QSw Industry Inc · Wilmington, DEBuilt 1965 · S/N 751N5785UZanino James A · Sterling, MABuilt 1970 · S/N 28-26609N5785WLilu LLC · Siloam Springs, ARBuilt 1964 · S/N 28-1671N5786FPalazzi Michael A · Longmeadow, MABuilt 1968 · S/N 28-25094N5786HLynn Leroy D · New Carlisle, OHBuilt 1949 · S/N 16-402N5786PMckowan Sheila R · Chatsworth, CAS/N 24-865N5786QMartinez Todd P · Vacaville, CABuilt 1965 · S/N 3095N5786UCampbell Ashley H · Colorado Springs, COBuilt 1969 · S/N 28-26611N5786WPowers Meranda M · Nampa, IDBuilt 1964 · S/N 28-1676N5787BWilliams Thomas C · Fort Myers, FLBuilt 2003 · S/N 90111N5787DWyoming Development LLC · Cheyenne, WYBuilt 1960 · S/N 1623N5787HLagace Donald O · Augusta, MEBuilt 1949 · S/N 16-403N5787UCodreanu Octavian · Thorndale, PAFirst renewal noticeBuilt 1969 · S/N 28-26612N5787WNewsome Robert K · Linwood, NCBuilt 1964 · S/N 28-1680N5787ZFaust David E · Windber, PAS/N 22-9631N5788HMillar George B · Le Claire, IABuilt 1949 · S/N 16-404N5788QMccabe David P · Tower, MNBuilt 1965 · S/N 3096N5788WTech Flight Corp · South Hamilton, MABuilt 1964 · S/N 28-1688N5789DTripacer Bretheren LLC · Longview, WABuilt 1956 · S/N 22-4465N5789FKarnegis Frank J · Senoia, GABuilt 1968 · S/N 28-25096N5789HBlumer Charles · Fullerton, CAS/N 16-405N5789PNiche Pharmaceuticals LLC · Shorewood, MNBuilt 1959 · S/N 24-868N5789QWayden John R · El Paso, TXBuilt 1965 · S/N 873N5789WLewandowski Robert G · Crestwood, KYBuilt 1964 · S/N 28-1693N578BWBridgewater State University · Bridgewater, MABuilt 1998 · S/N 17280522N578CAChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10807N578FLChapin William C · Jackson, MIBuilt 1971 · S/N 28-7125430N578GVGrant Aviation Inc · Anchorage, AKBuilt 2004 · S/N GA8-04-066N578KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843901N578KSMisurelli Francis X · Lake Hopatcong, NJBuilt 2004 · S/N 40.429N578MCChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 172S9578N578QWWhelchel Leon · Vinton, IAFirst renewal noticeBuilt 1978 · S/N 13N578RVGembala Gary L · Strongsville, OHBuilt 2012 · S/N 80882N578SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881402N578ZAAviat Aircraft Inc · Afton, WYBuilt 2026 · S/N 3477N5790DJohnston Jeff · Edgewood, NMBuilt 1956 · S/N 22-4466N5790FRenner Thomas F · Chandler, AZBuilt 1968 · S/N 28-25097N5790LSeveca Ventures LLC DBA · Arcola, TXBuilt 1969 · S/N AA1-0190N5790QSurman Stephen · Draper, UTBuilt 1965 · S/N 3097
Back to AD 81-18-04 R2